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 vote114 views1 answer
Search from comma separated values in sql server
SQL
0 vote114 views1 answer
Find invalid datetime field
SQL
0 vote123 views1 answer
Sql find all different values in column
SQL
4 votes123 views2 answers
How to insert ip address in mysql using php
SQL
3 votes110 views2 answers
Laravel tosql with bindings
SQL
0 vote119 views1 answer
Stored procedure function relation
SQL
0 vote134 views1 answer
Pgadmin check database
SQL
9 votes112 views1 answer
Mysql check date range
SQL
28 votes112 views4 answers
Show tables mysql
SQL
0 vote116 views1 answer
Pl sql round
SQL