• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 367
  • Last Modified:

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

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
Patriotec
Asked:
Patriotec
  • 4
  • 2
1 Solution
 
arbertCommented:
"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
 
PatriotecAuthor Commented:
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
 
arbertCommented:
So, what about the windows update or new software installations?  Something changed on the machine to break your "working connection".  What was it???
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
arbertCommented:
Also, you have a couple VERY old questions that need to be taken care of....
0
 
PatriotecAuthor Commented:
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
 
arbertCommented:
Post a question in CS and have them close it....You might take care of you other older questions as well....
0
 
Computer101Commented:
PAQed - no points refunded (of 250)

Computer101
E-E Admin
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now