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 vote350 views1 answer
How to find total working hour in sql
SQL
0 vote324 views3 answers
Get free card roblox
SQL
2 votes325 views1 answer
Oracle number to percentage
SQL
3 votes332 views3 answers
Mysql order by list
SQL
1 vote324 views4 answers
Mysqldump 1 table only
SQL
0 vote330 views1 answer
Vbscript clean up ADODB.Recordset
SQL
10 votes325 views2 answers
Sql rtrim
SQL
0 vote325 views1 answer
Prepared statement mysql java delete selected rows
SQL
5 votes345 views2 answers
Mysql create database charset utf8mb4
SQL
3 votes364 views1 answer
Select count from table mysql
SQL