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 vote197 views1 answer
Import excel to sql
SQL
0 vote194 views1 answer
Delete first row in sql
SQL
1 vote200 views1 answer
Mysql illegal mix of collations for operation 'join'
SQL
11 votes188 views4 answers
Query DISTINCT
SQL
0 vote219 views1 answer
Remove mysql from centos 7
SQL
0 vote191 views1 answer
Sql add calculated column
SQL
10 votes195 views1 answer
Oracle dependencies table
SQL
4 votes191 views1 answer
Mysql timestamp in laravel migration
SQL
24 votes192 views5 answers
Sql server insert into select
SQL
1 vote239 views1 answer
OSError: mysql_config not found
SQL