Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2004-08-15
8
Medium Priority
?
364 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
Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

 
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

916 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