How to connect two differect instances of SQL SERVER on LEN or WAN for Data Migration.MSDN (http://msdn.microsoft.com/sql)
and read about linked servers, DTS, replication...|||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/ArticleID/37794/37794.html for further information.sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment