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 vote368 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
0 vote295 views1 answer
Postgres multiple left join causing duplicates jsonb_agg
SQL
0 vote252 views1 answer
How to Group by and concatenate arrays with all columns in PostgreSQL
SQL
0 vote309 views1 answer
Sql query inline if
SQL
1 vote316 views1 answer
Sql random sampling per group
SQL
1 vote206 views1 answer
Convert money to varchar sql server
SQL
0 vote277 views2 answers
Plsql regex match whole word
SQL
32 votes288 views6 answers
Sql count where
SQL
0 vote272 views1 answer
Sql create text column limited values
SQL
2 votes318 views1 answer
Python sql
SQL