Post reply

Installing SQL Server 2005 and SQL Server 2000 on same server

  • July 21, 2009 at 9:14 am

    #132110

    Can anyone point me to a document that describes how to install SQL Server 2005 on a server that is already running SQL Server 2000. (I found the "Working with Multiple Versions of SQL Server" Article but it does not provide the steps.) I know this can be done. I am just wondering if the SQL Server 2005 Files would be kept separate (in a different directory) than the SQL Server 2000 Files. Would the SQL Server 2005 Program Files be placed in a different directory than the SQL Server 2000 Program Files? The SQL Server 2000 Installation has a default instance. So, I would have to provide a named-instance for the SQL Server 2005 Install. Would this named-instance be used to create the directory structure for the SQL Server 2005 Install?

    Thanks in advance, Kevin

  • July 21, 2009 at 9:16 am

    #1027697

    Hopeful enough infor in the link below

    http://mattiasgeniar.be/2008/07/16/installing-sql-2000-and-sql-2005-on-the-same-server/

  • July 21, 2009 at 2:14 pm

    #1027910

    Thanks sql_lock. I have another question:

    I have a default instance of SQL Server 2000 running on Windows Server 2003 R2 SE SP2. May I install a named instance of SQL Server 2005 and a named instance of SQL Express 2005 on the same machine (running SQL Server 2000)? This would be three instances of SQL Server (SQL 2000, SQL 2005 and SQL Express 2005) running on one machine.

    Thanks in advance, Kevin

  • July 21, 2009 at 2:54 pm

    #1027945

    Also, if I am able to install 3 Instances (sql 2000, sql 2005 and sql express 2005) on the same machine, how should I divide up the memory (3GB) between the three instances. This is a test machine so there is not a lot of user activity.

    Thanks, Kevin

  • July 21, 2009 at 10:48 pm

    #1028088

    You will need to installed SQL 2k SP3 (as stated in the link).

    Within each SQL Server instance you can set the Min/Max memory. Make sure you leave enough the OS 😉

  • July 22, 2009 at 2:43 am

    #1028141

    Each SQL Server instance is considered a separate SQL Server installation, and so yes, it will have it's own separate directory structure. Looks like others have already pretty much covered the rest. 🙂

    Kind regards,

    Vegard Hagen
    Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
    @vegard_hagen on Twitter
    Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)

    It is better to light a candle than to curse the darkness. (Chinese proverb)

  • July 22, 2009 at 9:40 am

    #1028439

    With each SQL Server Instance, do you set the memory during the install or after the install? To set the memory after the install, I believe you right click the server and select properties and then the Memory Tab. There are 3 options:

    1) Dynamically configure SQL Server memory

    2) Use a fixed memory size (MB)

    3) Reserve physical memory for SQL Server

    I am thinking I would use Option 2 to divide the memory up among the different instances and leave some for the o/s.

    Is this correct?

    Thanks, Kevin

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

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