We get several calls related to setup and installation questions. One such common question is related to installation of SQL 2000 and SQL 2005 on the same box.
Through this blog, we will try to address these commonly asked questions.
You can install SQL 2000, SQL 7.0 and SQL 2005 on the same box. However, there are certain special considerations that you should be aware of.
First, refer to this comparison sheet published by Microsoft at the MSDN website.
This sheet can be used as a handy reference to decide if your planned configuration is supported or not.
Now, let’s look at some of the specific scenarios.
Emphasizing the need for SP3 or SP4
If you want to install SQL 2005 and SQL 2000 on the same box, you must patch SQL 2000 to SP3 or above. Let me explain why.
In SQL Server 2000, the identification of the server connection endpoints is performed by the SQL Server service. SQL Server 2005 replaces that function with the SQL Server Browser service.
In case you have SQL 2000 already installed, the SQL Server Service is will listen at UDP port 1434. However, when you install SQL 2005 on the same box, the SQL Browser service will wait for 5 seconds for SQL 2000 to relinquish port 1434.
With SQL 2000 SP3 and above, this works fine. However, versions earlier than SP3 do not properly share port 1434 and may not make your instances of SQL Server available to requesting client applications. The SQL Server Browser might fail to start in instances running on less than SP3.
To resolve this problem with versions of SQL Server 2000 earlier than Service Pack 3, stop SQL Server 2000, start SQL Server Browser, then restart SQL Server 2000. The SQL Server 2000 listener service continues to attempt to start on port 1434; therefore, the instance of SQL Server 2000 should be upgraded to Service Pack 3 as soon as possible.
SQL Server 7.0 has no similar capabilities and has no conflicts with SQL Server Browser.
Pretty much the same, but with some special consideations.
· You can install SQL 2005 x64-bit edition with SQL 2000 32-bit edition with SP4
· You can install SQL 2005 32-bit edition with SQL 2005 x64-bit edition
For more information on SP3, refer to our blog here. More information on SP4 can be found here.
Information on SQL 2005 SP1 and its hotfix rollup 2153 can be found here.
POSTED BY : Sanchan Saxena