IIS - windows authentication - Asked By abinav shankar on 25-Apr-13 03:10 AM

Hi


I have authenticated my application using my credentials in IIS7 and I don't want to enter the login credentials in sql server and I want my application to perform windows authentication how to do it

 
add following in web config with correct information


<add name="connectinname" connectionString="user id=USERID;pwd=PASSWORD;data source=DATABASE SERVER;initial catalog=DATADASENAME;" providerName="System.Data.SqlClient" />

Assuming you mean using the windows user account for actual connection to the database (versus a generic sql user that everyone would use), you'd do something like this:

http://msdn.microsoft.com/en-us/library/ff647396.aspx