none
Connecting to SQL server using Windows Auth + WCF RRS feed

  • Question

  • Hi,

    I am trying to use the windows authentication for connecting to sql server from WCF.

    The scenario is:

    asp.net application connects with WCF service to get data from Database.

    Now i dont want asp.net application to pass any credentials to WCF service but want the WCF service to connect to SQL server using a particular domain account.

    The domain account will have permission on the db.

    What i can currently think of is changing the application pool identity to Domain Account should work thought have not tried this. 

    Please let me know if there are any other approach to the same or any other settings i need to achieve the same.

    Thanks,


    Chandan Mahajan

    Sunday, January 6, 2013 7:52 PM

Answers