<div>
You want to install SQL Server using ClickOnce?
</div>


You want to install SQL Server using ClickOnce?

<div>
yes and then add a database to it
</div>


<div>
Let's start with deploying SQL Server then<br />
<br />
<a href="http://blogs.msdn.com/b/manisblog/archive/2008/12/22/how-to-deploy-sql-server-2008-express-as-clickonce-prerequisite.aspx" rel="ugc">http://blogs.msdn.com/b/manisblog/archive/2008/12/22/how-to-deploy-sql-server-2008-express-as-clickonce-prerequisite.aspx</a>
</div>


Let's start with deploying SQL Server then

http://blogs.msdn.com/b/manisblog/archive/2008/12/22/how-to-deploy-sql-server-2008-express-as-clickonce-prerequisite.aspx [http://blogs.msdn.com/b/manisblog/archive/2008/12/22/how-to-deploy-sql-server-2008-express-as-clickonce-prerequisite.aspx]

<div>
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.
</div>


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.

<div>
<div class="content wysiwyg-content">
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.
</div>
</div>


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.

Install and setup a local sql database and password using clickonce

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).