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

2 votes369 views1 answer
Mysql select default if null
SQL
0 vote359 views1 answer
Pl sql round
SQL
0 vote394 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL
4 votes418 views4 answers
Check constraint in ms sql
SQL
23 votes368 views4 answers
Uninstall postgresql ubuntu
SQL
0 vote417 views1 answer
Database disk image is malformed sqlite fix ubuntu
SQL
0 vote392 views1 answer
Mysql workbench Error Code: 2013. Lost connection to MySQL server during query
SQL
0 vote374 views1 answer
Mysql listing get a particu particular user firsdt
SQL
0 vote348 views1 answer
Mysql import datetime YYYY-MM-DDThh:mm:ss.000000Z
SQL
1 vote373 views1 answer
Pgsql sum switch case
SQL