Click here to Skip to main content
13,511,994 members
Rate this:
Please Sign up or sign in to vote.
My application’s bootstraper downloads and install SQL Server Express, up to this part everything is fine. My issues are:

1) I want to install it with such parameter that the sa password is set as my given password, instead user has to use SSMSE and change it.

2) In Status, Setting are done automatically as ‘Permission to Connect to DB Engine is Grant and ‘Login’ is Enabled (by default it is Disabled)

3) SQL Server Browser Service should be ‘running’

4) User should not need to use SQL Server Surface Area Config.and It should automatically set to ‘Local and Remote Connections’ with Using TCP / IP only’

Please advise how to achieve these goals.

Posted 18-Jan-13 20:53pm
Updated 18-Jan-13 20:56pm
RedDK 21-Jan-13 14:49pm
I think you missed a step. You need to create a database. And to do that you'll be applying a lot of the principles found in the help available through Visual Studio. Presumeably this application's downloader is wired in to that tome.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web03 | 2.8.180417.1 | Last Updated 19 Jan 2013
Copyright © CodeProject, 1999-2018
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100