Sql Express installed using Package deployment does not provide change 'sa' password

[Nilam2477]

I want to deploy my application which requires .Net framework, SQL Express as prerequisites. So i created a setup project in VS2008 and selected .Net framework and SQL Server 2005 Express.
Now while installing my application at client's site, it first installs .Net framework followed by SQL Express 2005. But while installing SQL Express it does not prompt for the user to set the password for 'sa' user. There is no dialog displayed for user selection. It installs in windows authentication mode. Is there a way to set the SQL Server autentication mode. Please note that i dont want to install SQL Server Management studio.
Your help is appreciated
Thanks

[Echidna]

Hi,

Easiest way is to add the following into the setup.ini file

under options

SECURITYMODE=SQ L

You can also set the SA Password

SAPWD= somemeaningless string

You can also set the Server Login Mode through the registry after install through the registry

For Default install with no instance name set

USE [master]
GO
EXEC xp_instance_reg write N'HKEY_LOCAL_MA CHINE', N'Software\Micr osoft\MSSQLServ er\MSSQLServer' , N'LoginMode', REG_DWORD, 2
GO

If there is an instance name set

USE [master]
GO
EXEC xp_instance_reg write N'HKEY_LOCAL_MA CHINE', N'Software\Micr osoft\Microsoft SQL Server\Instance Name\MSSQLServe r', N'LoginMode', REG_DWORD, 2
GO

Hope this helps

Cheers

Leon