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 vote192 views1 answer
Sql server manager close connection
SQL
0 vote158 views1 answer
'0000-00-00' for column '
SQL
2 votes214 views1 answer
Mysql cannot delete or update a parent row
SQL
0 vote185 views1 answer
Sqlite to csv statement
SQL
0 vote205 views1 answer
How we can perform acid Operations in sql with examples
SQL
1 vote209 views1 answer
Trim leading zeros in sql
SQL
0 vote183 views1 answer
Ms sql database data size
SQL
0 vote220 views1 answer
Get total and distict row diff in sql
SQL
0 vote200 views2 answers
Replace null with 0 in sql
SQL
8 votes193 views1 answer
Today minus 15 days postgresql
SQL