Cannot connect to MSSQL DB from webpages using ASP, error in event viewer
Posted on 2004-08-15
Using windows 2003 and MS SQL Sever 200 w/SP3, Dual Proc Tyan S3022 Motherboard, 2GB Registered DDR RAM
This is the error messages that I get in Event Viewer and their descriptions
Warning 8/15/2004 11:44:42 MSSQLSERVER (8) 19011
Description:SuperSocket info: (SpnRegister) : Error 1231.
Error 8/15/2004 11:44:42 MSSQLSERVER (8) 19011 N/A DOMAIN
Description: SuperSocket info: gethostbyname(MSAFD Tcpip [TCP/IP]) : Error 11004.
Now I've already re-installed SQL Server but for some strange reason TCP/IP cannot be uninstalled.
This literally happened suddenly. I was developing some web pages( everything was working fine) then when I came back in about 15 minutes (the computer does not go into sleep or suspend or hibernation) it did not work. Then I looked in the event viewer and received those error messages. It's not the code, because 3 other iterations of the website are running live right now on other machines.
I RDP'd into the box at my office and restored the SQL backup (from the now "dead db connection" computer) and it worked fine.
Searched google and no helpful hits. Any ideas?? Just wanted to prevent re-installing the OS.