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 vote299 views1 answer
Mysqlcli how to load external sql file
SQL
0 vote291 views1 answer
Mysql date time string format for marshmellow field schema
SQL
3 votes281 views1 answer
Oracle limit user tablespace
SQL
1 vote293 views1 answer
Sql Split string function
SQL
0 vote312 views1 answer
Enable outgoing remote MySQL access
SQL
0 vote295 views1 answer
Sql getdate minus 1 day without time
SQL
0 vote314 views1 answer
ORA-13717
SQL
0 vote317 views1 answer
Date datatype in livesql
SQL
0 vote282 views1 answer
Sql database size
SQL
8 votes284 views5 answers
Alter table add column with default value
SQL