المساعد الشخصي الرقمي

مشاهدة النسخة كاملة : Sql Express installed using Package deployment does not provide change 'sa' password option



C# Programming
01-26-2010, 01:20 PM
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