Connecting web service to sql server using app pool account

[dragonfly99]

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 or web.config change etc...i am really confused how to set it up so if somebody can guide me step by step I would really appreciate it.



Thanks

 

[jbenson001]

Google is your friend! Start here:

http://msdn.microsoft.com/en-us/library/aa292118(VS.71).aspx

 

[dragonfly99]

Thanks JBenson..the link was good..but here are my problems..i cannot enable the site to have anonymous access..and i have to set impersonation=true because my webservice runs under sharepoint web app and so impersonation has to be there and it is the logged on user credential...but what i wanted is that in my web service how do i take the app pool account and pass it to sql server..is there some setting for this in connection string.

Thanks

 

[jbenson001]

I don't understand whatyou mean by an app pool account.

 

[dragonfly99]

Application pool account ...the credentials which the web application uses for running..i have a domain account specifically for the web application's application pool and i wanted that this account should be passed always to access sql server no matter which user logs in...let me know if i need to explain more.

 

[jmeckley]

you want the website/IIS to use impersonation except when the service connects to the database. this seems overly complex. why not:
1. use the user's account to connect to the database?
2. use sql server account and configure the connection string to use the account?

this is much easier to manage and makes more sense given your constraints.

Jason Meckley
Programmer
Specialty Bakers, Inc.

faq855-7190
faq732-7259