When trying to connect to my SQL Server, I receive an error message.

When trying to connect to your SQL Server database, you receive an error similar to the following:

A connection could not be established - Client unable to establish connection

ConnectionOpen(CreateFile())..



Please verify SQL Server is running and check your SQL Server registration properties...



-OR- [Microsoft]Client unable to establish connection

This problem is caused when your SQL Server client utilities are configured to use a default network protocol other than TCP/IP.

Resolution

Follow these steps to resolve the problem:

 

  1. From Windows, click the Start button, then Programs, then Microsoft SQL Server 7.0, then Client Network Utility. The SQL Server Client Network Utility dialog appears.
  2. From the tabs at the top of the dialog, click General.
  3. Find the list box labeled Default network library and select TCP/IP from the list.
  4. Click the OK button.
  • 12 Users Found This Useful
Was this answer helpful?

Related Articles

Where can I find documentation for ServerObject's AspMail component?

This documentation can be found at: http://www.serverobjects.com/products.html For...

How do I upload files through my web pages?

You can use Software Artisan's SAFileUP. This is an ASP component that allows you to upload files...

What is PageCounter and how do I use it?

About Page Counter PageCounter is an object that counts and displays the number of times a Web...

How do I setup Microsoft Outlook Express to read my e-mail?

Follow these steps: Open Microsoft Outlook Express. From the Tools menu, click...

How do I setup Netscape Messenger to read my e-mail?

Follow these steps: Open Netscape Navigator. Click the Edit menu and then click Preferences......