Login | Register   
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Jul 15, 1999

Connection

Question:
I have a small SQL Server 6.5 database running on NT Workstation. From my workstation I can ping that machine and I can map a drive to that machine.

However, every time I try to connect through SQL Server I get a network error stating that the SQL database does not connect or there is a general network failure.

What is wrong? (I was able to connect briefly at one time, but no more.)

Answer:
Just because the machine is alive doesn't guarantee that the server is. Is the server running? (Open the Control Panel, click on Services, and check the list to see whether MSSQL is started.) Is it possible that named pipes were not included during the installation?

The fact that it worked once and no longer does raises the issue of a recent network/user_name/security/hardware (NIC)/some other recent configuration change being suspect, no?

Sorry I couldn't be of more help. It's a dark place to be in.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap