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

1 vote289 views1 answer
Raise application error in oracle
SQL
2 votes298 views4 answers
Check timezone of mysql database
SQL
0 vote278 views1 answer
Sql server sleep
SQL
20 votes272 views4 answers
Reset auto increment in MySQL
SQL
17 votes280 views2 answers
Mysql date to string
SQL
0 vote318 views1 answer
Min varias colunas spark sql
SQL
0 vote294 views1 answer
SQL SERVER xquery count child nodes
SQL
0 vote302 views1 answer
Offset in postgresql example
SQL
0 vote344 views1 answer
Oracle convert int to date
SQL
1 vote315 views1 answer
Mysql workbench requires visual c++ 2019 redistributable package
SQL