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

57 votes734 views6 answers
Sql alter table
SQL
0 vote151 views1 answer
Can we rollback deleted data in sql
SQL
0 vote176 views1 answer
Create relationship with betwen two tables in postgersql
SQL
0 vote163 views1 answer
Sql values that contains certain multiple ids
SQL
0 vote157 views2 answers
Laravel: customize or extend notifications - database model
SQL
5 votes160 views3 answers
Mysql remove unique constraint
SQL
0 vote208 views1 answer
Sql commands in android
SQL
8 votes165 views4 answers
How to calculate the age from date of birth in python
SQL
0 vote159 views2 answers
MySQL top percent
SQL
2 votes162 views2 answers
Postgres add column integer
SQL