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

0 vote255 views1 answer
Mysql to get column name in database
SQL
3 votes254 views2 answers
Enter mysql command line
SQL
1 vote256 views1 answer
Decalre temp table sql
SQL
0 vote255 views1 answer
T-sql check if data exists
SQL
9 votes275 views5 answers
Sql delete duplicate rows but keep one
SQL
0 vote282 views1 answer
Hour and minute between two datatime sql
SQL
0 vote257 views1 answer
Sql server beginning of month
SQL
1 vote249 views1 answer
Loading local data is disabled mysql
SQL
0 vote269 views1 answer
How to set sql_mode for a query in CI model
SQL
4 votes262 views1 answer
Describe table mysql
SQL