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

9 votes364 views4 answers
How to alter table column name in mysql
SQL
-1 vote297 views1 answer
How to create script to connect to oracle database and run query
SQL
4 votes330 views1 answer
Postgresql show current database
SQL
0 vote339 views2 answers
Sql 2 way of select unique
SQL
0 vote329 views1 answer
C# select Mysql
SQL
0 vote346 views1 answer
Mysql disable query caching
SQL
0 vote410 views1 answer
Com.mysql.cj.exceptions.InvalidConnectionAttributeException more than one time zone. You must configure either the server or JD value if you want to utilize time zone support.
SQL
7 votes355 views1 answer
Oracle reset sequence
SQL
0 vote682 views1 answer
Create pl/sql stored procedure
SQL
0 vote398 views2 answers
Pl sql auto increment
SQL