Installing new instance on already installed sql server PC

  • In my PC i have already installed sql server 2008 express with a default instance name.(SQLEXPRESS). Now i want to install another instance of same(sql server 2008 express).How can i do it?

  • run the installer and when it askes to give your server a name, give it a different name than SQLEXPRESS

  • Additionally, if you want to work with the two instances simultaneously you must set up different listening ports for them.

    IgorMi

    Igor Micev,My blog: www.igormicev.com

  • So should i run the setup again? Or is there any other method by which i can install new instance(named instance) by using already installed sql server.

  • Run setup again, it is the only way to install a new server (instance)

  • If i go to SQL Server Installation Center and click on Installation hyperlink and then on new installation.. then it asks for installation media.(from link http://social.msdn.microsoft.com/forums/en-us/sqlsetupandupgrade/thread/F6C35A03-B98C-46F1-8010-0A76DF8773D5)

    Can i install new instance from this without using new setup file?

    I required this because some of my customers already have sql server 2008 express installed. What i want is new instance on their computer.So downloading setup again is a problem.So i was interested in installing it from existing installation.

  • You need the media, so either combine it within your application to do an install when they install your app or manually download it and install.

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

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