|
Home > Archive > MS SQL Server ODBC > November 2005 > SQL server 2000 installation
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL server 2000 installation
|
|
| Nada Sherief 2005-11-08, 9:23 am |
|
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/d...nstall_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/d...server_4uuq.asp
HTH, Jens Suessmeyer.
|
|
|
|
|