I am examine the different possibilities of SharePoint & Reporting Services Native Mode vs. Integrated Mode. So i set up an environment with both possibilities.
I have a SharePoint farm with following components: SQL Server 2008 + Reporting Services (Native Mode) SharePoint 2010 Server + Reporting Services (SharePoint Integrated Mode)
On the SharePoint server i am able to view the reports that are on my reporting server in native mode as the ones that are in Integrated Mode.
But when I browse from a client pc to my sharepoint site, I only can access the reports from Native Mode. Those of SharePoint Integrated Mode return the following error
Cannot create a connection to data source 'MY-SQLSERVER-NAME'. (rsErrorOpeningConnection)
Do i run into the double hop problem (I use NTLM)? Or is there another issue?