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 vote235 views1 answer
Mysql select statement after index
SQL
2 votes219 views1 answer
Mysql sysdate
SQL
3 votes220 views1 answer
Postgres update column with value from another table
SQL
0 vote234 views1 answer
How to set sql_mode for a query in CI model
SQL
0 vote228 views1 answer
Python sqlalchemy orm to select null values
SQL
1 vote252 views1 answer
Postgres see sequence current state
SQL
0 vote216 views1 answer
Mysql workbench download for iinux mint 19.3
SQL
2 votes268 views1 answer
Postgresql group by month and year
SQL
0 vote210 views1 answer
Sort by last two number sql
SQL
0 vote236 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL