Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server:

[phplooser]

Hi

 

Im getting this error from a site I have hosted on an internal server.

 

Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: server in C:\Freight\common.inc.php on line 3

 

the connection string is

 

<?php

session_start();

mssql_connect("server", "freight_mssql", "randoM1");

mssql_select_db("spk_freight");

?>

 

you see the funny thing is that this connection was working all along and then decided to drop. As far as i can make out sql server is up and running fine and so is IIS. So its a real noggin scratcher to why its not connecting up.

 

One thing that it may have caused it (im just guessing here) is that i was cleaning up old redundant users in the active directory of that server, would it be possible that by deactivating or deleting old profiles that i may have knocked it off that way? 

     

any ideas guys?

[trq]

Have you tried actually checking to see if mssql is running and that the user exists?

[phplooser]

Have you tried actually checking to see if mssql is running and that the user exists?

 

Hi,

 

Yes my sql server is running and the user "freight_mssql" is running. I am confused

[phplooser]

Have you tried actually checking to see if mssql is running and that the user exists?

 

Hi,

 

Yes my sql server is running and the user "freight_mssql" is running. I am confused

 

I got it working. I just restarted the IIS and it seems to be ok again.