September 10, 2003 at 8:41 am
How does a Query analyzer communicate with a remote sql server? I mean what are the steps in the process...cud someone enlighten me here....
Arvind
Arvind
September 10, 2003 at 9:38 am
Hi there
How remote are we talking, inter-company? or over the WAN?
Within your network (LAN) is very simple. The instance itself starts with a listener, the server network utility at the server controls the protocols/ports in which you can connect to the instance with. Use this utility to verify the settings or the sql server log. Any change will require a restart of the instance as the listener is inheritly connected to the instance itself (which is a shame actually). From the client, you can using the native MDAC providers, such as OLEDB, ADO etc.. or other ODBC drivers, these talk over the active listener protocols to the instance to establish the connection. If you have a named instance over a nondefault port, it can be a pain to sort out, use the client network utility to establish an alias to the instance to ease the process of connecting.
Cheers
Ck
Chris Kempster
Author of "SQL Server 2k for the Oracle DBA"
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
September 10, 2003 at 11:04 pm
Thx Ck.. What i meant here was...typically what are the steps involved in the execution of a query from a client over LAN. What are the various steps that go on in the background when u fire a query from the query analyzer client.
Cheers!
Arvind
Arvind
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply