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 vote139 views1 answer
Find all tables where column name exists oracle
SQL
0 vote133 views1 answer
Acual month sql
SQL
21 votes134 views1 answer
SQL cheat sheet pdf
SQL
0 vote169 views1 answer
Find wordpress version in database
SQL
0 vote140 views1 answer
Version_info, _mysql.version_info, _mysql.__file__ NameError: name '_mysql' is not defined
SQL
6 votes139 views2 answers
How to get yesterday date in mysql
SQL
7 votes156 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL
0 vote171 views1 answer
Suhaib
SQL
0 vote144 views1 answer
How to connect to mysql in ef 6
SQL
0 vote157 views1 answer
SQL Server INSERT INTO SELECT By Complete Examples - NAYCode.com
SQL