Solved

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

Posted on 2004-08-15
8
353 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
Comment Utility
"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
Comment Utility
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
Comment Utility
So, what about the windows update or new software installations?  Something changed on the machine to break your "working connection".  What was it???
0
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

 
LVL 34

Expert Comment

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

Author Comment

by:Patriotec
Comment Utility
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
Comment Utility
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
Comment Utility
PAQed - no points refunded (of 250)

Computer101
E-E Admin
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

In this article—a derivative of my DaytaBase.org blog post (http://daytabase.org/2011/06/18/what-week-is-it/)—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
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…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

772 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

16 Experts available now in Live!

Get 1:1 Help Now