Nada Sherief wrote:
> 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.

You can either install two named instances of SQL Server or install a
single default instance and one named instance. During the install, you
see options for both. You can add linked servers to connect from one
server to the other. See "How to install a named instance of SQL Server
2000 (Setup)" and sp_addlinkedserver in BOL.

--
David Gugick
Quest Software
www.imceda.com
www.quest.com