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 vote193 views3 answers
Sql server obtener fecha en formato dd/mm/yyyy
SQL
14 votes219 views2 answers
Oracle add attribute to table
SQL
3 votes227 views1 answer
Ms sql skip take
SQL
0 vote171 views1 answer
Jooq finding lastest value in table
SQL
2 votes187 views4 answers
ModuleNotFoundError: No module named 'mysql'
SQL
14 votes231 views2 answers
Sql cast
SQL
0 vote235 views1 answer
Html css mobile menu arrow dropdown
SQL
10 votes205 views3 answers
How to fetch first 5 characters in sql
SQL
10 votes248 views6 answers
Mysql set root password
SQL
2 votes278 views1 answer
Brew start postgres manual
SQL