none
Can we install SQL Server 2005 Enterprise edtion and Standard edition on same Serever?

    Question

  • Hi,

    We have SQL Server 2005 ENTERPRISE EDITION (ins1) and it is running in production. Now we got a requirement to install another instance(ins2) of SQL Server 2005 STANDARD EDITION on the same server.

    Before starting the installation of Standard edition, I would like to know is this possible or not? please advice me

    Thanks
    Tuesday, August 04, 2009 5:29 AM

Answers

  • Yes, it is possible to have several instances of different editions.
    Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi
    Tuesday, August 04, 2009 6:33 AM
  • Hi,

    SQL Server 2005 Enterprise edition has more features then SQL Server 2005 Standard Edition. It doesn’t support degrading a SQL Server   2005 Enterprise edition instance to Standard Edition. Therefore, before log shipping, you cannot restore the existing a SQL Server 2005 Enterprise edition database to Standard Edition.

    If there are any more questions, please let me know.

    Thanks.


    ***Xiao Min Tan***Microsoft Online Community***
    Thursday, August 06, 2009 4:39 AM

All replies

  • Yes, it is possible to have several instances of different editions.
    Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi
    Tuesday, August 04, 2009 6:33 AM
  • I concur with Tibor that this is possible but the actual question is why? Why do you want to install another edition on the same box? Have you verified that the current instance (EE) is NOT running under memory issues? and there is plenty of RAM to spare for the second instance? How will you use this SE? WHat will be the usage patterns for this box? 

    In general SQL Server will try to grab as much as memory available upto the max server memory setting or if it is available if the max. memory setting is not configured. If this is NOT checked correctly then the two instances may compete for resources which may NOT be good for either instances.

    | Sankar Reddy | http://sankarreddy.spaces.live.com/ |
    Tuesday, August 04, 2009 6:48 AM
  • Good point, Sankar. Another point is: If you decide to installed a second instance, why not make that EE as well. You are most likely already covered by the license for the first installed instance (see MS licence pages for details).
    Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi
    Tuesday, August 04, 2009 6:56 AM
  • thank you,

    the reason to install Standard edition is "We have Log shipping configuration setup between 2 SQL server 2005 Enterprise editions.

    Primary: SQL Server 2005 EE and Secondary: SQL Server 2005 EE

    Now we want to Log ship a new SQL Server 2005  standard Edition instance Databases to Existing Secondary instance which is Enterprise Edition.

    So I'm not sure whether we can Configure log shipping between Standard and Enterprise edition and want to install another separate Standard edition and configure log shipping between new Primary standard edition & Secondary standard edition.

    If Configuring log shipping between Standard and Enterprise edition supports, then I will use the same Enterprise edition as secondary instance for this new standard edition instance (primary) databases too.

    Is Configuring log shipping between Standard and Enterprise edition supported? please confirm and take me to the MS link....


    thanks
    Tuesday, August 04, 2009 5:54 PM
  • Could you please give some info on this?

    thanks
    Wednesday, August 05, 2009 5:20 PM
  • Hi,

    SQL Server 2005 Enterprise edition has more features then SQL Server 2005 Standard Edition. It doesn’t support degrading a SQL Server   2005 Enterprise edition instance to Standard Edition. Therefore, before log shipping, you cannot restore the existing a SQL Server 2005 Enterprise edition database to Standard Edition.

    If there are any more questions, please let me know.

    Thanks.


    ***Xiao Min Tan***Microsoft Online Community***
    Thursday, August 06, 2009 4:39 AM