Is it possible to install 2 instances of SQL Server 2000/2005 on same PC? If Yes how

My application uses SQL Server 2000/2005 database as back end. It is required to setup multiple environments (development, QA, Pre-Prod etc) on same PC. Is it possible to install two instances of SQL Server in single PC to be referred by different applications installed for different environments? If yes, how to do it?

Thanks
unifiAsked:
Who is Participating?
 
Faiga DiegelConnect With a Mentor Sr Database EngineerCommented:
A combination of 2000 and 2005 versions?

You can install upto 50 instances.
http://technet.microsoft.com/en-us/library/ms143432.aspx
0
 
unifiAuthor Commented:
Can every instance have separate databases with the same names and database objects?
0
 
unifiAuthor Commented:
Thanks for response! I searched on internet and found out the steps to setup multiple instances of SQL Server on same machine.
0
 
Faiga DiegelSr Database EngineerCommented:
Yes. As long as it is in different instance.
0
All Courses

From novice to tech pro — start learning today.