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 vote305 views1 answer
TSQL function split string
SQL
0 vote263 views1 answer
Online sql compiler
SQL
10 votes318 views1 answer
Oracle object dependencies
SQL
19 votes316 views2 answers
Mysql tinyint max value
SQL
0 vote320 views1 answer
Linebreak sql
SQL
1 vote348 views1 answer
Nullif postgresql
SQL
13 votes307 views4 answers
Mysql select last 10 rows
SQL
1 vote338 views3 answers
Alter schema sql server
SQL
1 vote336 views1 answer
Tsql update datetime
SQL
0 vote320 views1 answer
Date on SQL
SQL