Investigating mssql_connect problems in PHP

Question

Today, I restarted my CentOS server and after that my PHP application started to fail in accessing our MsSQL server.

[Sun Mar 13 23:44:31 2011] [error] [client 88.154.*.*]
PHP Warning:  mssql_connect()
[<a href='function.mssql-connect'>function.mssql-connect</a>]: Unable to connect to server:  85.*.*.109

• MsSQL server uses port 1433.
• I'm able to get a connection when I try telnet ip 1433 to MsSQL server.
• Username and password combination is correct, I'm able to login from another machine.
• Nothing has been changed in security settings of MsSQL server.

How can I see what's wrong?

Answer 1

did you double check and make sure that ALL of sql server's services have started?