Installer Win Forms Application with SQL Server 2014 Database
<p>I have developed an application with VB.Net and SQL Express 2014. I have created a installer using inno setup. The Database files (mdf &amp; ldf) are bundled along with the installer and are installed in a separate DB folder with 'Full' access rights.</p>

<p>The connection string is as follows:</p>

<pre><code> &lt;add name="MyApp.My.MySettings.MyAppConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=&amp;quot;C:\Program Files\MyAppDB\MyApp.mdf&amp;quot;;Integrated Security=True"
            providerName="System.Data.SqlClient" /&gt;
</code></pre>

<p>I am using the SQL Server as a Local Instance application with Windows Authentication without login id &amp; password for the sql server.</p>

<p>The installation is usually done by a person from the IT dept with Admin rights but when the intended user uses it refuses to connect to the server as the user does not have the rights. If the user is made as an administrator then the application is able to connect to the SQL Server. (Of course, the SQL Server needs to 'Security' permissions to be given manually thru windows explorer file properties menu - the user has to be 'added up' to the list of permitted users with 'Full Control').</p>

<p>But in some instances  the IT dept refuses to give the user the 'Admin' credentials and it becomes a security issue.</p>

<p>I tried googling for some time and found info, but just could not solve the issue of the app + sql server working for a 'non-admin' user who has not installed the app..</p>

<p>Hope I have explained it enough..</p>

<p>Kindly help me to over come this issue..</p>

<p>Thanks
Renga</p>