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 vote346 views1 answer
Postgresql la fonction dblink_connect(unknown, unknown) n'existe pas
SQL
5 votes329 views1 answer
Sql select ciunt
SQL
0 vote338 views1 answer
Where date major today mysql
SQL
0 vote341 views1 answer
Mysql listing get a particu particular user firsdt
SQL
1 vote324 views2 answers
Mysql remove first and last character from string
SQL
10 votes307 views1 answer
All_dependencies
SQL
0 vote324 views1 answer
Restart sql server command line linux
SQL
0 vote354 views1 answer
SQL: calculate hours from two dates
SQL
1 vote333 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL
0 vote307 views1 answer
Select row from mysql where date more than 30 days
SQL