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 vote379 views1 answer
How to remove identity from a column in sql server
SQL
1 vote356 views1 answer
How to make a select in sql
SQL
6 votes379 views2 answers
Mysql 1 day ago
SQL
2 votes420 views1 answer
Cannot return non-composite value from function that returns composite type
SQL
7 votes418 views3 answers
Sql server check if temp table exists
SQL
2 votes344 views2 answers
Laravel query builder toSql
SQL
0 vote340 views1 answer
How to count with except in psql
SQL
0 vote390 views1 answer
Sqlite get date only
SQL
0 vote336 views1 answer
How to get n result in sql
SQL
0 vote361 views1 answer
Add unique constraint sql server multiple columns
SQL