how to connect a remote SQLserver using widows authentication from a .net application, if possible
<p>currently I am using this connection string inside the app.config file of the application</p>

<pre><code>add name="LightSailEntities" connectionString="metadata=res://*/LightSailEntities.csdl|res://*/LightSailEntities.ssdl|res://*/LightSailEntities.msl;provider=System.Data.SqlClient;provider connection string='data source=abc.xyz.com;initial catalog=LightSail;user id=LightSail; password=yourpasswordhere;MultipleActiveResultSets=True;App=EntityFramework'" providerName="System.Data.EntityClient"
</code></pre>

<p>The domain of .Net application and the domain of client, using .Net application, is different from domain of SQL server. I mentioned <strong>"using widows authentication"</strong> only because of, I have the access of the server machine(means I can use Remote Desktop Connection) on which the SQL server is installed.</p>
