Moron Posted December 30, 2011 Share Posted December 30, 2011 I coded an employee information system a few years ago and it has evolved all along, with new features being added and such. Well, we recently added a new SQL 2008 server and migrated it all over there. This was done by a consultant and he basically migrated all databases and user accounts to the new server. I changed my code to point to the new server and it worked like a champ. That is, until a couple of days ago....... It worked great for the last month and a half. Now, it suddenly won't connect any longer ("Unable to connect to database _____....."). I can change the code to point back to the old server and it works fine again. One of the other guys double- and triple-checked the accounts on the new server and they match. The old server is SQL Server 2000. The new one is SQL server 2008 R2. Any help is greatly appreciated! Quote Link to comment https://forums.phpfreaks.com/topic/254049-weird-ms-sql-connection-suddenly-stopped-working/ Share on other sites More sharing options...
Muddy_Funster Posted December 30, 2011 Share Posted December 30, 2011 How are you connecting to the server and what does your app use to connect to the database? Has there been any windows updates installed arround that time (event loggs should tell you) Quote Link to comment https://forums.phpfreaks.com/topic/254049-weird-ms-sql-connection-suddenly-stopped-working/#findComment-1302487 Share on other sites More sharing options...
Moron Posted December 30, 2011 Author Share Posted December 30, 2011 Thanks, but it's resolved. It was a matter of replacing the "ntwdblib.dll" file on the server with the PHP code accessing the database. As for how it suddenly stopped working, I have no idea. Quote Link to comment https://forums.phpfreaks.com/topic/254049-weird-ms-sql-connection-suddenly-stopped-working/#findComment-1302583 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.