2005 Setup Project: Installing SQL Server Express prerequisite with command line parameters

[Velislav]

Hi, I've got a setup project which installs SQL Server Express as a
prerequisite to my program.

The problem is that by default it's installed using the SQLEXPRESS
instance name and Windows Authentication login mode.

I'd like to have my own instance name and SQL Authentication, which is
easily achieved with command line parameters... is there a way to
specify that sort of thing?

Thanks

[Chan Ming Man]

SQL question actually but anyway.

Try this and let me know whether you can get it done.
http://msdn2.microsoft.com/en-us/library/ms143799.aspx

chanmm

"Velislav" <vg*****@gmail.comwrote in message
news:11*********************@v45g2000cwv.googlegro ups.com...

Hi, I've got a setup project which installs SQL Server Express as a
prerequisite to my program.

The problem is that by default it's installed using the SQLEXPRESS
instance name and Windows Authentication login mode.

I'd like to have my own instance name and SQL Authentication, which is
easily achieved with command line parameters... is there a way to
specify that sort of thing?

Thanks

[Velislav]

Thanks, all I'm trying to do is get the bootstrap, which my set up
generates, to run the SQL Server Express setup file with the following
command-line arguments:
/qn SECURITYMODE=SQL SAPWD=mySaPassword INSTANCENAME=myInstanceName

(I just thought this is an appropriate place to ask this question as it
has more to do with Setup & Deployment than SQL itself)

Chan Ming Man wrote:

SQL question actually but anyway.

Try this and let me know whether you can get it done.
http://msdn2.microsoft.com/en-us/library/ms143799.aspx

chanmm

[Velislav]

I found the solution:
http://forums.microsoft.com/MSDN/Sho...29450&SiteID=1