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 vote112 views1 answer
MySQL INSERT IGNORE Statement
SQL
0 vote124 views2 answers
Impala rename column name
SQL
0 vote102 views1 answer
Sqlcmd xml output insert line break after every 2033 characters
SQL
0 vote119 views1 answer
Oracle NLS_CHARACTERSET
SQL
0 vote113 views1 answer
Mysql url
SQL
10 votes134 views4 answers
Fetch first 5 characters of the string in sql
SQL
0 vote107 views1 answer
Set default value now() date
SQL
0 vote118 views1 answer
Mysql type for large numbers with many decimal
SQL
-1 vote115 views3 answers
Update mongodb version ubuntu
SQL
0 vote109 views1 answer
Mysql replication change database name
SQL