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 vote210 views3 answers
Join
SQL
0 vote180 views1 answer
Hw to delete a procedure in pl sql
SQL
4 votes176 views3 answers
Sql find second highest salary employee
SQL
0 vote179 views1 answer
Call rest api from postgresql
SQL
1 vote197 views1 answer
Change table to innodb mysql
SQL
0 vote229 views1 answer
Set Mamp mysql globally
SQL
0 vote312 views1 answer
Mysql select field if condition
SQL
6 votes236 views1 answer
Postgresql get year
SQL
0 vote192 views2 answers
Call to undefined function mysqli_fetch_all()
SQL
2 votes192 views1 answer
Query any digits record
SQL