Installing SQL Server Express 2005 from VS setup project - named instance

Question

I'm installing SQL Server Express 2005 from my Visual Studio 2008 setup project.

This works fine and installs the instance "SQLExpress".

Does anyone know if you can pass it some kind of command line to install or change a property to give it a different instance name?

It might help if you describe exactly how you invoke the Sql Server installation from your setup project. — ArildF
– ArildF, Commented Dec 14, 2010 at 18:20
Just the standard setup project pre-requisites bootstrapper (so it does it itself) — DomBat
– DomBat, Commented Dec 15, 2010 at 9:05

ArildF · Accepted Answer · 2010-12-14 18:24:08Z

1

If you are calling out to SQL Server's setup.exe from your installer I believe you can pass the instance name as an argument, like this: setup.exe INSTANCENAME=YourInstance

See here for more info: http://technet.microsoft.com/en-us/library/ms144259(SQL.90).aspx

answered Dec 14, 2010 at 18:24

ArildF

4263 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

DomBat · Accepted Answer · 2010-12-21 11:52:50Z

0

See this article on how to edit the bootstrapper that installs SQL as part of the setup. There is indeed an INSTANCENAME attribute (and you can also pass DEFAULTDATABASE and all sorts of useful command line parameters).

http://www.windowsdevelop.com/clickonce-setup--deployment-projects/generic-bootstrapper--sql-express-named-instance-18693.shtml

answered Dec 21, 2010 at 11:52

DomBat

2,1235 gold badges28 silver badges42 bronze badges

Collectives™ on Stack Overflow

Installing SQL Server Express 2005 from VS setup project - named instance

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related