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?