This is a discussion on SQL server 2000 installation within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> hello, 1-I want a detailed step by step tutorial for installing SQL server 2000. 2- I want to install ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| hello, 1-I want a detailed step by step tutorial for installing SQL server 2000. 2- I want to install two SQL servers 2000 on the same machine, how could i do that? (i mean will there be any change in the installation to the second server?) 3- I want to know how to connect between these two servers. thanx all for help |
| ||||
| Hi Nada, 1-I want a detailed step by step tutorial for installing SQL server 2000. -Put in the installion disk, install a second instance (named instance) http://msdn.microsoft.com/library/de...stall_259u.asp 2- I want to install two SQL servers 2000 on the same machine, how could i do that? (i mean will there be any change in the installation to the second server?) -See point 1. Every instance is treated as a separate server aus every service is independent to the other. 3- I want to know how to connect between these two servers. You have to attach the servers as linked servers in order to see them. Them you can access them with the four part notation: e.g. Select * from Servername.DatabaseName.owner.Objectname http://msdn.microsoft.com/library/de...erver_4uuq.asp HTH, Jens Suessmeyer. |