Sql Express installed using Package deployment does not provide change 'sa' password option
C#
1
Posts
1
Posters
0
Views
1
Watching
-
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 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