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

3 votes231 views1 answer
Postgresql today - 1 year
SQL
2 votes139 views1 answer
How to check if a row is null in sql
SQL
0 vote181 views1 answer
Sql filter rows with condition
SQL
0 vote174 views1 answer
ORACLE PARSE STRING
SQL
1 vote156 views1 answer
Mysql strict_trans_tables
SQL
0 vote160 views1 answer
Postgres change the name of schema
SQL
24 votes142 views4 answers
Postgres remove database
SQL
2 votes144 views2 answers
How to rename column name in sql server using query
SQL
0 vote146 views1 answer
Create user faunadb
SQL
5 votes142 views2 answers
Sql create tabel with primary key auto_increment code
SQL