locked
Connecting web service to sql server using app pool account RRS feed

  • Question

  • User-730945238 posted

    Hello,

    I have a web service in which i am making connection to the database to get data..now i want that the app pool account should be used to make the connection and not the current user's credentials..can somebody tell me step by step what changes do i need to make  like setting impersonation=true etc...i am really confused how to set it up.

     

    Thanks 

    Tuesday, June 15, 2010 9:27 AM

Answers

  • User-1071894543 posted

    1. Replace the application pool account to an application user (instead of NETWORK_SERVICES) and give it's password

    2. Add the account to IIS_WPG users group on your app server

    3. Grant the user with the needed permissions on the database

    4. Don't change the web.config (You shouldn't impersonate, if you did, change it back)



    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, June 16, 2010 7:52 AM