Solved

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

Posted on 2004-08-15
8
356 Views
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.

0
Comment
Question by:Patriotec
  • 4
  • 2
8 Comments
 
LVL 34

Expert Comment

by:arbert
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?
0
 
LVL 1

Author Comment

by:Patriotec
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.
0
 
LVL 34

Expert Comment

by:arbert
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???
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 34

Expert Comment

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

Author Comment

by:Patriotec
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???
0
 
LVL 34

Expert Comment

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

Accepted Solution

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

Computer101
E-E Admin
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

832 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