February 18, 2006 at 10:12 am
Has anyone installed Sql server 2005 (standard Edition) in a separate directory on the same hard drive and the same server with Sql server 2000 ? If so, any issues? I want to set this up on my home test box for learning purposes. Thanks in advance.
February 21, 2006 at 2:21 am
"In SQL Server 2000, the identification of the server connection endpoints was performed by the SQL Server service. SQL Server 2005 replaces that function with the SQL Server Browser service. If you install SQL Server on a computer that is also running SQL Server 2000 or MSDE, you must ensure that SQL Server 2000 or MSDE is upgraded to Service Pack 3 (SP3) or later. Versions prior to SP3 do not properly share port 1434 and may not make your SQL Server instances available to requesting client applications. Although you can change the services startup order so that the SQL Server Browser service starts before SQL Server 2000 or MSDE, the recommended resolution is to update all older versions of SQL Server to the latest service pack.
When an instance of SQL Server 2000 is installed on the computer, if the SQL Server Browser is not running, the SQL Server 2000 listener service starts. If SQL Server Browser starts after the listener service, it waits 5 seconds for SQL Server 2000 to give up port 1434. If that does not occur, SQL Server Browser fails to start. To resolve this problem with versions of SQL Server 2000 prior to 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, so the SQL Server 2000 instance should be upgraded to service pack 3 as soon as possible."
~BOL
February 26, 2006 at 7:21 pm
And to further answer your question - we currently have SQL2000 installed along side of an instance of SQL2K5 and both appear to be running happily enough.
No problems as yet.
February 28, 2006 at 1:59 pm
I have MSDE 2000 SP3A and SQL Server 2005 Developer Edition running on my machine with no problems. MSDE 2000 is a default instance, SQL 2005 is a named instance.
June 7, 2007 at 10:51 am
When having both versions on the same server, did you change the port that one of them use or are both using 1433?
thanks,
Joe
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply