Re: server running ok, but cannot connect using ip address

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

  • Next message: peter: "Re: How can I tell what protocols are enabled for the client?" 
    Date: Tue, 22 Jun 2004 05:26:34 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 16 Jun 2004 16:07:37 GMT, dudebig <hhugg@hotmail.com.no-spa.m>
    wrote:

    >I can do everything with the server on the local LAN, but can make
    >connection if using ip address of server. please help.

  • Next message: peter: "Re: How can I tell what protocols are enabled for the client?"

    Relevant Pages

    • Re: How can I tell what protocols are enabled for the client?
      ... If your application connects thru the alias, ... secure network connectivity for SQL Server 2000 local databases) ... >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? ...
      (microsoft.public.sqlserver.connect)
    • Re: request/response style profiling
      ... Not having a public protocol certainly does NOT mean that there's no way to ... parse the binary data. ... some client access libraries such as ADO ... SQL Server MVP ...
      (microsoft.public.sqlserver.tools)
    • Re: How to retrieve stored procedure error code in C#?
      ... Mark and William - thx for the replies, as they pointed me in the right ... > All Sql Server stored procedures have a return value parameter, ... > Please do not send email directly to this alias. ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: Merge Replication using ip address to distributor/publisher
      ... is no enterprize manager or client network utility. ... I also read that alias to ip address can be programmed in subscriber ... register the Publisher in Client Network Utility." ... Looking for a SQL Server replication book? ...
      (microsoft.public.sqlserver.replication)
    • change a named instance to default instance
      ... Produced By Microsoft MimeOLE V6.00.2800.1441 ... even though there is only one SQL Server ... | Is there anyway I can make my named instance behave like the default? ... Configure an Alias by Using TCP/IP Sockets ...
      (microsoft.public.sqlserver.connect)