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 vote305 views1 answer
Psql show db
SQL
18 votes302 views3 answers
Mysql add column default value
SQL
0 vote284 views2 answers
Mysql regexp match word
SQL
0 vote270 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
-1 vote272 views1 answer
Mysql coalesce
SQL
5 votes263 views2 answers
Mysql where in array
SQL
0 vote289 views1 answer
Mac os zsh: command not found: mysql
SQL
1 vote262 views1 answer
Mysql order by desc null last
SQL
5 votes305 views4 answers
Start postgres server
SQL
1 vote302 views1 answer
How to copy data of a table from another database to table of anaother database
SQL