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

0
votes

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?

2
sqlvisual-studio-2008sql-server-2005installationsetup-project
It might help if you describe exactly how you invoke the Sql Server installation from your setup project. - ArildF
Just the standard setup project pre-requisites bootstrapper (so it does it itself) - DomBat

2 Answers

1
votes

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

0
votes

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