Test sqlsrv connection

Php connect ms sql server

<?php
$serverName = "serverName\\sqlexpress"; //serverName\instanceName

// Since UID and PWD are not specified in the $connectionInfo array,
// The connection will be attempted using Windows Authentication.
$connectionInfo = array( "Database"=>"dbName");
$conn = sqlsrv_connect( $serverName, $connectionInfo);

if( $conn ) {
     echo "Connection established.<br />";
}else{
     echo "Connection could not be established.<br />";
     die( print_r( sqlsrv_errors(), true));
}
?>

Source: php.net

Test sqlsrv connection

$serverName = "serverName\\sqlexpress"; //serverName\instanceName

// Since UID and PWD are not specified in the $connectionInfo array,
// The connection will be attempted using Windows Authentication.
$connectionInfo = array( "Database"=>"dbName");
$conn = sqlsrv_connect( $serverName, $connectionInfo);

if( $conn ) {
     echo "Connection established.<br />";
}else{
     echo "Connection could not be established.<br />";
     die( print_r( sqlsrv_errors(), true));
}

Similar codes

1 vote228 views2 answers
Grab part of a string sql
SQL
0 vote221 views1 answer
Postgresql using reserved word as column name
SQL
5 votes229 views3 answers
Bash: mysql: command not found
SQL
0 vote219 views1 answer
Create table in dbms cmds
SQL
0 vote240 views1 answer
Vs 2019 connect to local mysql database
SQL
4 votes208 views3 answers
Create database in mySQL
SQL
1 vote229 views3 answers
Drop unique key constraint in sql server
SQL
0 vote228 views1 answer
Select into table variable
SQL
1 vote229 views1 answer
Mysql show queries running
SQL
0 vote231 views1 answer
Import Data in MySQL without using any other software
SQL