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:
$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?