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

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>

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
>

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