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

2 votes318 views1 answer
Use cases condition in sql query laravel
SQL
10 votes338 views5 answers
Create table mysql query
SQL
0 vote321 views1 answer
Postegresql update to null
SQL
0 vote328 views2 answers
Sql auto update dupdated_at
SQL
0 vote308 views1 answer
Connect to nginx server mysql remotly
SQL
1 vote309 views1 answer
Mysql current time
SQL
0 vote377 views2 answers
Mysql insert rows to another database
SQL
18 votes301 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
0 vote348 views1 answer
For row in sql database python loop
SQL
0 vote297 views1 answer
Sql database connectivity
SQL