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


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

replied to abinav shankar on 25-Apr-13 05:23 AM
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" />
Robbe Morris replied to abinav shankar on 25-Apr-13 07:33 AM
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: