Re: How can I tell what protocols are enabled for the client?

From: Mark Ferguson (Mark_Ferguson_at_noname.com)
Date: 06/22/04 

Date: Tue, 22 Jun 2004 05:22:09 GMT

If your application connects thru the alias, then the protocol for the
alias is used. If the application connects thru the instance then the
*enabled* protocols for the instance are used.

See the following
http://support.microsoft.com/default.aspx?kbid=814130 (How to help
secure network connectivity for SQL Server 2000 local databases)
and
http://support.microsoft.com/default.aspx?scid=/support/servicepacks/SQL/2000/SP3aReadMe.asp
(The Readme file for SP3)
and
The SQL Server Books Online (find on the microsoft.com, download and
install)

On Mon, 21 Jun 2004 14:34:02 -0700, "=?Utf-8?B?cGV0ZXI=?="
<peter@discussions.microsoft.com> wrote:

>If on the General tab of the Client Network Utility, TCP/IP is the only protocol enabled. Does it mean that other protocols are disabled and will not be used in communicating to SQL Servers on other machines?
>In this case, should the registry HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SuperSocketNetLib only contains the Tcp entry?
>If I have alias setup to use other protocol such as Named Pipes, does it mean the alias cannot be connected since Named Pipes is not enabled?
>

Relevant Pages

  • Re: Winsock Transport Service Provider
    ... Please do not send e-mail directly to this alias. ... If I get an AF number from IANA, will Microsoft add the AF number to ... I have a transport protocol in TDI and I also provide Winsock ... Do I have to register to Microsoft to register ...
    (microsoft.public.development.device.drivers)
  • Re: Winsock Transport Service Provider
    ... Please do not send e-mail directly to this alias. ... I have a transport protocol in TDI and I also provide Winsock ... Address families are added by Microsoft when a new family ... Do I have to register to Microsoft to register ...
    (microsoft.public.development.device.drivers)
  • Re: smx-0.0.0.0 smar defunct with map socket aliases
    ... appended to the alias (with my code or with sockmapsrv): ... That most likely means that the RHS of the map is incorrect. ... The value for an alias entry is a list of one or more RFC 2821 ... it's in the protocol specification. ...
    (comp.mail.sendmail)
  • Re: server running ok, but cannot connect using ip address
    ... If your application connects thru the alias, then the protocol for the ... secure network connectivity for SQL Server 2000 local databases) ...
    (microsoft.public.sqlserver.connect)
  • Re: Connect to SQL Sererv thru Named Pipes
    ... to acced SQL Server via Named Pipes from VB 6. ... The DBMSSOCN tell the OLEDB driver to use TCP/IP instead of the default ... There are pros and cons as normal for which protocol to use however IMO ...
    (microsoft.public.vb.general.discussion)