February 3, 2008 at 10:30 pm
Hi All
Is it possible to run sql server 2000 and sql server 2005 in a same
machine.
After i install sql server 2005 ,I'm not able to access sql server 2000.
How can i do this.Pls share your valid ideas with me
My OS is windows server 2003
Thanks Josh
February 3, 2008 at 11:08 pm
Sure it's possible. 2000 has to be installed first and can be the default or a named instance. SQL 2005 must be installed second and must be a named instance.
Make sure when you install 2005, you specify that it's a new named instance, not an upgrade of the existing 2000 one.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 4, 2008 at 12:08 am
I have the very same configuration on my development machine. I have full access to both 2000 & 2005 servers and client tools. As Gail said, make sure you do not make it an upgrade, 2005 must go on as a named instance.
You can then connect to each instance as (assuming your computer is called COMPUTER)
2000: COMPUTER
2005: COMPUTER\sql2005
where sql2005 is the name you gave to the named instance in SQL Server's installation.
February 4, 2008 at 1:52 am
Hi gail
thank you for your valuable advice
Josh
February 4, 2008 at 10:49 am
Also if you are going to install the DTS components for SQL 2005 make sure you are on SP4 for SQL 2000 or Enterprise Manager won't work anymore.
Kenneth
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
February 4, 2008 at 2:36 pm
GilaMonster (2/3/2008)
Sure it's possible. 2000 has to be installed first and can be the default or a named instance. SQL 2005 must be installed second and must be a named instance.Make sure when you install 2005, you specify that it's a new named instance, not an upgrade of the existing 2000 one.
The 2005 instance does not have to be a named instance for both to live happily on the same machine.
February 5, 2008 at 1:17 am
This is even recommended configuration for upgrade. Remeber that in cluster you can even run both on the same default port 1433 (not recommended).
MCP ID# 1115468 Ceritified Since 1998
MCP, MCSE, MCP+I, MCSE+I, MCSA,
MCDBA SQL7.0 SQL 2000, MCTS SQL 2005
February 5, 2008 at 5:47 am
I have succesfully build SQL Server 2005 as the first and default instance, then installed SQL Server 2000 as a named instaNCE.
Why do you want to retain a SQL Sever 2000 instance?
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply