Post reply

Default Instance

  • October 24, 2010 at 6:33 pm

    #143778

    Can we have Default instance of SQLServer 2008 and SQL Server 2005 on same box?I have an sql server 2008 as default instance and i need to install sql server 2005 default instance on same box so is there any way like i can stop the services(2008) and install 2005 as default instance with out uninstalling sql server 2008 ?

    Thanks in advance 🙂

  • October 24, 2010 at 7:30 pm

    #1241392

    For a default instance, there can be only one. all other additional instances would have to be named instances.

    if your current default is 2008, and you HAVE to have a 2005 default instance you'll have to uninstall 2008.

    why can't you use a named instance for your 2005?

    RamSteve (10/24/2010)

    Can we have Default instance of SQLServer 2008 and SQL Server 2005 on same box?I have an sql server 2008 as default instance and i need to install sql server 2005 default instance on same box so is there any way like i can stop the services(2008) and install 2005 as default instance with out uninstalling sql server 2008 ?

    Thanks in advance 🙂

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • October 25, 2010 at 12:51 am

    #1241431

    I agree with Lowell. Having two different SQL servers on the same computer are pretty much why named instances exist in the first place, so why can't you use them?

Viewing 3 posts - 1 through 2 (of 2 total)

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