SQL Server 2005, SQL Server 2000 Side-by-Side Installation on the same server

Hot Topic

Getting an error "SQL Mobile encontered a problem when openeing the database; the path is not valid"
new fact records
T-SQL Catch-all error handling?
Aggregates in Matrix Reports
execution cached schedule
Connect to SQL Server from Application on different domain
Synchronization of Business Contacts in Outlook with Small Business Accounting
Scrpting to genrate surrogate keys
Can we save a data structure in a SQL Server Database?
Is an output parm needed?

SQL Server

Package Migration Wizard error -- Index was out of range
How to backup asymmetric key in SQL 2005
MIIS 2003
Where can I find the infamous Microsoft.SQLServer.Broker download?
raw file source avoid bad data?
Linked servers and Windows Authentication
Pubs not installed?
Scripting entire DB to multiple files or comparing DB objects
Management Studio Express CTP update now available
seperate fields for first, last and middle in access db

SQL Server 2005, SQL Server 2000 Side-by-Side Installation on the same server

I am planning on installing SQL Server 2005 first and then install SQL Server 2000 as a separate instance on the same server. Has anyone had any experience with this setup When I ran the SQL 2000 set up it didn't force me to create a new instance but I still did. I also installed the files on different directories c:\program files\ just in case. If you have any experience of ideas about this configuration, please let us know. Thanks.

Answer this question

SQL Server 2005, SQL Server 2000 Side-by-Side Installation on the same server

  • Jeff Williams

    yes that is correct

    Install SQL Server 2000 then 2005 - I have done this and works fine all the time ;-)

    Just make sure the instance name is different unless you are doing an upgrade or something



  • Fredrik Melin

    Thanks for all the comments. I will make sure I follow your recommendations. I am doing the side by side installation to provide backward compatibility while upgrading people to SQL Server 2005. I would like to use just the default instance for SQL SErver 2005 and make the instance name <servername>\SQL2000 for my SQL Server installation. Thanks for all the guidelines.

  • Paul.Davis

    If you install SQL 2000 after SQL 2005, you can hit problems during installation. It's always better to install SQL 2000 first, then SQL 2005. If you don't have any problems, then nothing to worry about.

  • Alquimista09

    Hi, I have a 300gig db on SQL2000. Can I install SQL2005 and the db will still be accessible to users, or can I run them side by side, meaning the users will still access the db on 2000

  • Mchafu

    Hi Peter

    Thanks a lot. I installed 2005 without uninstalling 2000. After the installation, the DB was attached and working 100%. Only problem is that I dont get SQL Agent to start, which means I cannot do any Maintenance Plans!!!!!! Please assist.

    Hannes

  • kwix

    You can install SQL2005 on the same machine as SQL 2000. Are you looking to import the database into SQL 2005 If so, you will need to test to ensure everything is fine. If you are planning to keep the database in SQL2000, then all will be fine.

    Thanks

    Peter Saddow



  • jack zhao


    HannesCoetzee wrote:

    Hi Peter

    Thanks a lot. I installed 2005 without uninstalling 2000. After the installation, the DB was attached and working 100%. Only problem is that I dont get SQL Agent to start, which means I cannot do any Maintenance Plans!!!!!! Please assist.

    Hannes



    I would like to know the answer to this as well...
  • SQL Server 2005, SQL Server 2000 Side-by-Side Installation on the same server
Answer this question