Varieties of SQL Connection Protocol

Although rarely causing the problem, the SQL connection protocol is crucial in getting the user to reach the database.

The information as to how many ways SQL Server provide the connection protocol is recorded in its log, the ERRORLOG text file, usually resides in C:\Program Files\Microsoft SQL Server\MSSQL\LOG

Below is example of typical connection protocols in SQL Server 2000 :

2009-01-31 14:36:12.30 server SQL server listening on Shared Memory.

This is the most simple connection, it enabled SQL Server to provide communication with the client in the same machine

Or

2009-01-31 14:36:12.30 server SQL server listening on Shared Memory, Named Pipes.

This will enable remote client to connect to the server using named pipe.

Or

2009-01-22 16:45:24.10 server SQL server listening on TCP, Shared Memory, Named Pipes.

In this mode, beside the named pipe, SQL Server also serve the TCP/IP connection

In my experience, sometimes the connection problem is caused by the client is talking to the server only with the specific protocol, for example, the TCP/IP. So, pay attention to the above message.

If it does not say that it is listening on TCP or intended protocol, you should make it so, by obtaining and upgrade using latest SQL Server 2000 service pack.

Advertisements

One Response to “Varieties of SQL Connection Protocol”

  1. improve your memory Says:

    Thanks for sharing this nice cool stuff.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: