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 vote149 views1 answer
Sql how to duplicate a table
SQL
0 vote186 views1 answer
Month mysql
SQL
1 vote153 views1 answer
Isnull sql server
SQL
8 votes162 views1 answer
Oracle search stored procedures for text
SQL
0 vote156 views1 answer
Sql comand for removing data from table
SQL
2 votes144 views1 answer
SQL IF ELSE
SQL
0 vote193 views1 answer
Offset in postgresql example
SQL
0 vote162 views3 answers
Postgresql allow remote connections
SQL
0 vote194 views1 answer
Sql server remove primary key without dropping table
SQL
0 vote165 views2 answers
Collation in sql
SQL