Cannot connect to MSSQL DB from webpages using ASP, error in event viewer

Posted on 2004-08-15
Last Modified: 2008-01-09
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.

Question by:Patriotec
  • 4
  • 2
LVL 34

Expert Comment

ID: 11805120
"Now I've already re-installed SQL Server but for some strange reason TCP/IP cannot be uninstalled."

What do you mean TCP/IP cannot be installed???  You mean as the listening protocol???

Any chance you had a windows update in the last couple of days?  Install any new software?

Author Comment

ID: 11805368
tcp/ip can not be UNINSTALLED.  i was trying to uninstall then re-install the tcp/ip protocol, just to see if that was the problem.
LVL 34

Expert Comment

ID: 11805663
So, what about the windows update or new software installations?  Something changed on the machine to break your "working connection".  What was it???
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

LVL 34

Expert Comment

ID: 11805671
Also, you have a couple VERY old questions that need to be taken care of....

Author Comment

ID: 11980232
Well, it wasn't windows update or any "new software" that I coul find.

Tried to uninstall MSSQL and re-istall it. No worky. Basically uninstalled every other app that wasn't needed and no worky.

My solution, had to re-install, with all the current updates and now it works.

Hey how do I accept my own answer or close this question???
LVL 34

Expert Comment

ID: 11980546
Post a question in CS and have them close it....You might take care of you other older questions as well....

Accepted Solution

Computer101 earned 0 total points
ID: 12233255
PAQed - no points refunded (of 250)

E-E Admin

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now