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

    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
    Posts
    49
    MSDN
    and read about linked servers, DTS, replication....

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    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.
    http://www.winnetmag.com/Article/Art...794/37794.html for further information.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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