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

4 votes114 views2 answers
Sql server date now
SQL
1 vote116 views2 answers
Mysql filter by date mount
SQL
16 votes136 views3 answers
Get count of duplicate records
SQL
0 vote135 views1 answer
T-sql delete view if exists
SQL
1 vote156 views2 answers
Begin transaction sql
SQL
0 vote117 views1 answer
Mysql select statement after index
SQL
1 vote100 views1 answer
Sqlite check if row exists
SQL
0 vote125 views1 answer
Postgres clear table
SQL
0 vote121 views2 answers
Demmarrer un service mysql teminal cmd
SQL
0 vote126 views1 answer
Xamarin sql lite create table if not exist
SQL