Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2014-03-13
2
Medium Priority
?
510 Views
Last Modified: 2014-03-20
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?
0
Comment
Question by:Bruce
2 Comments
 
LVL 29

Accepted Solution

by:
becraig earned 1000 total points
ID: 39927311
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
 
LVL 75

Assisted Solution

by:käµfm³d 👽
käµfm³d   👽 earned 1000 total points
ID: 39928335
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Suggested Courses

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question