Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004

    Question Unanswered: How to connect two differect instances of SQL SERVER

    How to connect two differect instances of SQL SERVER on LEN or WAN for Data Migration.

  2. #2
    Join Date
    Jan 2004
    and read about linked servers, DTS, replication....

  3. #3
    Join Date
    Aug 2002
    Each instance of SQL Server 2000 listens on a unique set of network addresses so that applications can connect to different instances. SQL Server 2000 clients do not need any specific configuration to connect to an instance of SQL Server 2000.

    The SQL Server 2000 client components query a computer running one or more instances of SQL Server to determine the Net-Libraries and network addresses for each instance. The client components then choose a supported Net-Library and address for the connection automatically, without requiring any configuration work on the client.

    The only information the application must supply is the computer name and instance name. for further information.
    --Satya SKJ
    Microsoft SQL Server MVP

Posting Permissions

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