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

5 votes176 views2 answers
Oracle rename table
SQL
6 votes174 views2 answers
Oracle undotbs usage
SQL
0 vote191 views1 answer
Error: SAP DBTech JDBC: [258]: insufficient privilege: Detailed info for this error can be found with guid '87813FAA56439F48BD60812F3EBEC5A4'
SQL
2 votes167 views2 answers
Postgres select duplicate columns
SQL
2 votes197 views1 answer
Oracle log files
SQL
7 votes167 views2 answers
Html to react converter
SQL
1 vote204 views1 answer
Apex run 404
SQL
0 vote175 views1 answer
Create domain sql
SQL
2 votes170 views1 answer
Oracle convert run_duration to number
SQL
5 votes179 views3 answers
Day of week postgresql
SQL