MSSQL Connection

PHP
1

Hi Folks,
I am having trouble connecting to a remote SQL database.
I know the credentials are correct but still I get an ‘unknown error’ when I try to connect using this script:

<?php
$hostname_con_iris = "10.0.0.51";
$database_con_iris = "DB1";
$username_con_iris = "myusername";
$password_con_iris = "mypassword";
$con_iris = mssql_connect($hostname_con_iris, $username_con_iris, $password_con_iris) or trigger_error(mysql_error(),E_USER_ERROR);
?>

Does anyone have any idea what the problem could be?

2

Does the SQL Server allow remote connections for the user in question?

3

You asked the right question there logic_earth. I checked an the answer is no.
I will get that sorted then the script should work.

Thanks