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

5 votes118 views1 answer
Sql first day of current year
SQL
0 vote123 views1 answer
Mysql isshow
SQL
1 vote136 views1 answer
Install postgresql on raspberry pi
SQL
5 votes134 views2 answers
Sql constraint check value in list
SQL
0 vote148 views1 answer
"Hello User Name"
SQL
19 votes127 views6 answers
Sql create table
SQL
0 vote132 views1 answer
Sql server select top 2 of each group
SQL
0 vote211 views1 answer
"inspanel" intitle:"login" -"cannot" "Login ID" -site:luckyfish.io
SQL
1 vote117 views1 answer
Sql auto timestamp
SQL
0 vote134 views1 answer
Sql find record cannot cast date
SQL