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

1 vote137 views2 answers
Limit sqlserver
SQL
0 vote136 views1 answer
Intellij idea add mysql connector
SQL
25 votes162 views5 answers
Mysql replace text
SQL
0 vote170 views1 answer
Delete from table where length sql
SQL
0 vote144 views1 answer
Mssql describe stored procedure sqlcmd
SQL
8 votes141 views4 answers
Postgresql server restart
SQL
31 votes128 views3 answers
SQL Server change column data type
SQL
5 votes75 views1 answer
Copy table from one database to another mysql
SQL
0 vote128 views1 answer
Microsoft word insert sql code
SQL
1 vote132 views1 answer
How to copy data of a table from another database to table of anaother database
SQL