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

3 votes181 views1 answer
Pl sql check if variable is empty
SQL
0 vote197 views1 answer
Sql select non unique
SQL
0 vote211 views1 answer
Postgresql using reserved word as column name
SQL
12 votes199 views1 answer
How to change the value of a table in sql
SQL
0 vote230 views2 answers
What is 1=2 in sql
SQL
17 votes216 views3 answers
Postgresql version command
SQL
1 vote204 views1 answer
Mysql limit results to 10
SQL
0 vote189 views1 answer
An exception occurred while executing a transact-sql statement or batch user,group or role already
SQL
5 votes252 views4 answers
Rollback to in sql
SQL
2 votes194 views1 answer
Sql ignore accents
SQL