phplooser Posted October 8, 2009 Share Posted October 8, 2009 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? Quote Link to comment Share on other sites More sharing options...
trq Posted October 8, 2009 Share Posted October 8, 2009 Have you tried actually checking to see if mssql is running and that the user exists? Quote Link to comment Share on other sites More sharing options...
phplooser Posted October 8, 2009 Author Share Posted October 8, 2009 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 Quote Link to comment Share on other sites More sharing options...
phplooser Posted October 8, 2009 Author Share Posted October 8, 2009 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.