General information
Title:
Integrated Authentication and SQL Server Access
I am writing a ASP.net application. I have configured Web.Config to use Windows Authentication with Impersonation as follows:
authentication mode="Windows"
identity impersonate="true"
When I try to connect to my SQL database, it's trying to connect as the ASPNET user. That user does not have any rights to connect to my database (nor do I want to give them any rights).
I have done a lot of reading on the Identity and Principal classes, but still don't understand how to tell SQL server what user has been authenticated for my connection.
I know I must be missing something really obvious, I just can find it. Any ideas?
Mary Hintermeier (through Chris D'Arrigo)
RSA
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only