Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I have a sharepoint server and SQL server installed on different machines.

I created a web service which makes connection to the SQL serevr and gets data. If I test the web service it works.

Now when I create a web part in sharepoint and then use that web service to get data then it says error occured accessing a data source. When I make the web application anonymous then it gets the data from sql server.

I am deploying the web service in sharepoint layouts folder and I have code which runs with the web application app pool account. I want this app pool account to be passed to sql server, but it does not seem to pass the credentials.

Can someone please guide me on how to make this work?

share|improve this question

1 Answer 1

My first guess is Kerberos, make sure you have properly configured it. Take a look at this post, and also check the entire blog of Spence Harbars.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.