devxlogo

Connection

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.

See also  5 Tips for Choosing the Right Medical Software for Your Practice
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist