double hop issue in sharepoint
-
Hello , I have a sharepoint server and sql server installed on different machines...i created a web service which makes connection to 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 in which 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 working..i am really stuck ...let me know if i need to explain more. Thanks
-
Hello , I have a sharepoint server and sql server installed on different machines...i created a web service which makes connection to 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 in which 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 working..i am really stuck ...let me know if i need to explain more. Thanks