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 vote190 views1 answer
Sqlite display headers on columns
SQL
1 vote155 views1 answer
Sql set auto increment back to 0
SQL
0 vote126 views1 answer
Table or view does not exist
SQL
13 votes127 views2 answers
Sql count distinct group by
SQL
0 vote142 views1 answer
Create table with float datatype in sql server
SQL
1 vote138 views1 answer
Postgres count string length
SQL
5 votes219 views1 answer
Oracle asynchronous procedure
SQL
0 vote129 views1 answer
Sqlcmd no headers
SQL
17 votes158 views6 answers
Get last record in sql
SQL
0 vote136 views1 answer
Amount of entries in a table psql
SQL