How I a grant permission to an IIS web service to execute stored procs in a SQL Server database on the same server?

I've done this in the past but can't remember and I need this fast...

How I a grant permission to an IIS web service to execute stored procs in a SQL Server database on the same server?
LVL 1
BruceAsked:
Who is Participating?
 
becraigCommented:
Run the application under an identity (domain\user)

Grant the required permission in the db to that user.


That is one of the benefits of impersonation.

http://support.microsoft.com/kb/306158
0
 
käµfm³d 👽Commented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.