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 vote190 views1 answer
Insert and initialize a SQL column with value dependent on another column data
SQL
0 vote243 views1 answer
PDOException: SQLSTATE[HY093]: Invalid parameter numb
SQL
1 vote233 views2 answers
Datetrunc hour snowflake
SQL
-1 vote227 views1 answer
How to check table exists or not in postgresql
SQL
1 vote274 views1 answer
Sql server set variable if exists
SQL
2 votes225 views1 answer
Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column \\ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote245 views1 answer
Sql pad left 0
SQL
1 vote235 views1 answer
Operator does not exist: integer = text
SQL
1 vote233 views1 answer
Postgres first_value in gropby
SQL
1 vote237 views1 answer
Postgres check blocking
SQL