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

23 votes188 views4 answers
How to uninstall postgresql in ubuntu
SQL
0 vote183 views1 answer
Mysql set variable to today's date
SQL
7 votes180 views2 answers
What is sql clause
SQL
6 votes228 views2 answers
How to get last element sql
SQL
3 votes221 views4 answers
Mysql create table from select statement
SQL
0 vote356 views1 answer
Multiple row join
SQL
1 vote216 views1 answer
Mysql select update same table
SQL
1 vote294 views1 answer
Mysql monthname
SQL
0 vote169 views2 answers
Mysql password error create datbase
SQL
1 vote182 views1 answer
Md5 encryption for existing records
SQL