Install and setup a local sql database and password using clickonce

Hi I want to install and setup a local sql database using click once deploy. Then I can store the password in the app to user cannot access it.
LVL 3
taz8020Asked:
Who is Participating?
 
CodeCruiserCommented:
You can change the manifest file to add a password for sa account. You can then, through your application, remove current user from administrators so only someone with sa password can login

http://aspalliance.com/714_ClickOnce_Deployment_Customizing_SQL_Server_Express.all
0
 
CodeCruiserCommented:
You want to install SQL Server using ClickOnce?
0
 
taz8020Author Commented:
yes and then add a database to it
0
 
taz8020Author Commented:
yes but how do you setup a new instance and lock is to the user can not access it. I have seen this done by a few companies and like the idea. When you install their program it setups up a new instance and locks it with a usename and password and then installed the database so you cannot see the tables and data.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.