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.