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 vote188 views1 answer
T sql cursor tr
SQL
0 vote176 views1 answer
How to check even or odd in sql
SQL
0 vote192 views1 answer
Creating a simple notify in postgresql
SQL
1 vote176 views1 answer
Convert to hexadecimal sql
SQL
0 vote176 views1 answer
Mysql begin statement
SQL
2 votes181 views1 answer
Oracle list duplicates
SQL
0 vote171 views1 answer
Mysql select last 15 minutes
SQL
0 vote198 views2 answers
Mysql show foreign keys
SQL
0 vote187 views1 answer
Postgresql not in alternative
SQL
15 votes171 views2 answers
Sql order by multiple columns
SQL