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?
Does the SQL Server allow remote connections for the user in question?
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.
This topic is now closed. New replies are no longer allowed.