Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2004
    Posts
    21

    Unanswered: Connecting to SQL Server 2000 Named Instances

    I have the following problem;

    I fully understand that to connect to a named instance of SQL Server you need to use the ServerName\SQLInstanceName. The problem I have is that I have a SQL Server in a different zone. I can connect to the Default instance by IP Address or the ServerName.zone.domain.org. (e.g. MySQLServer.zone1.mydomain.org).

    However, the same thing does not work for the Named Instance. It seems to be named instance or nothing.

    How can I connect to this named instance across network zones?

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    use the instance name with the ip address, like 1.2.3.4\myInstance and you ought to be fine.

    -PatP

  3. #3
    Join Date
    Sep 2004
    Posts
    21
    That did it. Thanks!!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •