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

0 vote383 views1 answer
Fetching data from mysqldb
SQL
1 vote335 views1 answer
Oracle finding duplicate records
SQL
-2 votes354 views3 answers
How to fetch first 10 rows in sql
SQL
6 votes324 views1 answer
To count number of rows in SQL table
SQL
0 vote335 views1 answer
Create table with timestamp mysql youtube
SQL
5 votes323 views2 answers
Oracle tables with column name
SQL
2 votes362 views1 answer
Sql server check for value in multiple columns
SQL
1 vote385 views3 answers
How to reset id column in sql server
SQL
-1 vote346 views1 answer
Get id from just inserted row mysql server python
SQL
0 vote361 views1 answer
Select top values sql
SQL