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

16 votes162 views2 answers
Sql vs nosql
SQL
2 votes146 views1 answer
Check isolation level in mysql
SQL
2 votes163 views1 answer
Create delete procedure mysql
SQL
0 vote173 views1 answer
Pgadmin save data greyed out
SQL
9 votes167 views3 answers
Where clause sql
SQL
0 vote137 views1 answer
Find and replace database table phpmyadmin
SQL
0 vote130 views1 answer
Import sql mysql ubuntu
SQL
0 vote158 views1 answer
Remove mysql from centos 7
SQL
3 votes152 views1 answer
Sql double index
SQL
7 votes151 views4 answers
Index in mysql
SQL