Sql servwe 2000 and 2005 in a same server

Question

Sql servwe 2000 and 2005 in a same server

joshy mathew

Old Hand

Points: 361
More actions
February 3, 2008 at 10:30 pm

#120240

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

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Ian Yates SSCoach Points: 19738 More actions · Answer 2

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.

joshy mathew Old Hand Points: 361 More actions · Answer 3

joshy mathew

Old Hand

Points: 361

February 4, 2008 at 1:52 am

#774662

Hi gail

thank you for your valuable advice

Josh

Kenneth.Fisher SSC-Insane Points: 20396 More actions · Answer 4

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]

Adam Bean One Orange Chip Points: 26631 More actions · Answer 5

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.

berto SSCommitted Points: 1878 More actions · Answer 6

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

EdVassie SSC Guru Points: 60476 More actions · Answer 7

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