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 vote154 views1 answer
How to find unique key in sql
SQL
3 votes214 views1 answer
Mysql cli connect with password
SQL
11 votes193 views5 answers
Laravel db facade
SQL
0 vote183 views1 answer
Laravel migration sql dump
SQL
0 vote160 views1 answer
Java spring boot connect to sql server
SQL
1 vote180 views1 answer
Name of today sql
SQL
2 votes186 views1 answer
SELECT LOCKED FROM public.databasechangeloglock WHERE ID=1
SQL
0 vote164 views1 answer
Mysql earlier than date
SQL
1 vote161 views1 answer
Sql alchemy with azuresql server
SQL
0 vote192 views1 answer
Mysql aspas simples
SQL