NT athuntication for ASP.NET and SQL Server

[aky1234]

Hi,
Right now the the users are using basic authentication for loging into webpages and sql server authentication to access data base..My idea is to use just one WindowsNT authentication for both the web login and sql server..that is if the user is authenticated using windowsNT on the webpage ,he should be able to access DataBase aswell...How this Could be accomplished ??

 

[aky1234]

Hi,
Right now the users are authenticated using basic authentication for loging into webpages and sql server authentication to access data base..My idea is to use just one WindowsNT authentication for both the web login and sql server..that is if the user is authenticated using windowsNT on the webpage ,he should be able to access DataBase aswell...How this Could be accomplished ??

 

[ank2go]

Three things you'll need to do:

1. IIS - configure for "Integrated Windows authentication".

2. Web.config - change to use impersonation

3. SQL box - config to use "Integrated Windows authentication" for database.

HtH.