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

1 vote261 views1 answer
Oracle apex run 404
SQL
5 votes258 views1 answer
Oracle sysdate
SQL
4 votes276 views4 answers
Rollback in sql
SQL
1 vote305 views1 answer
Oracle create program if not exists
SQL
7 votes252 views1 answer
Sql management studio display line numbers
SQL
0 vote260 views1 answer
Alter table fulltext
SQL
1 vote290 views1 answer
Connect to mysql database ubuntu
SQL
0 vote304 views1 answer
Alternative for LIMIT sql
SQL
0 vote264 views3 answers
Find below average salary in sql
SQL
2 votes261 views2 answers
Mysql on duplicate key ignore
SQL