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

4 votes185 views1 answer
Change nls_date_format
SQL
3 votes260 views6 answers
Jwt laravel
SQL
1 vote194 views1 answer
Update foreign key value in mysql
SQL
2 votes237 views3 answers
Mysql kill
SQL
0 vote182 views1 answer
Subquery aggregation
SQL
33 votes173 views2 answers
Postgres how to add field created at
SQL
0 vote196 views1 answer
Mysql pad zeros
SQL
2 votes204 views1 answer
Merge firstname and lastname in sql oracle
SQL
0 vote178 views4 answers
Mysql count table rows
SQL
0 vote208 views1 answer
Mysql persistence.xml
SQL