I had the secured database sql server. I can't access the server using the php file connectivity.
The code
$myServer = "ippaddress";
$myUser = "XXXXXXX";
$myPass = "XXXXXXX";
$myDB = "XXXXXXX";
$conn = mssql_connect($myServer,$myUser,$myPass);
print_r($conn);
if (!$conn) {
die('Not connected : ' . mssql_get_last_message());
}
$db_selected = mssql_select_db($myDB, $conn);
if (!$db_selected) {
die ('Can\'t use db : ' . mssql_get_last_message());
}
And I tried this format of connect code also
$serverName = "serverName\instanceName"; //serverName\instanceName
$connectionInfo = array( "Database"=>"xxxxxx", "UID"=>"xxxxxx", "PWD"=>"xxxxxx");
$conn = sqlsrv_connect( $serverName, $connectionInfo
Every time I get an error:
page isn’t working" and "co.in is currently unable to handle this request.
Where I made mistake?