MSSQL Connection

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:

$hostname_con_iris = "";
$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.