ASP.NET identification with MS SQL Server

Here is an example connection string to the MS SQL Server. :
Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;
Password=myPassword;

Connection string using windows authentication:

Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security = true;

In <system.web> I have added <authentification mode=”Windows”/> <authorization><deny users=”?”/></authorization>

The result is that it take “NT Serviceblah blah” and tries to login with it which is not my case so I added:

<identity impersonate="true" />

and began taking the windows authentication of the current user.

To check additional connection strings check this website: http://www.connectionstrings.com/

You may also like...