Go 4 Sharepoint

Search:

Welcome: Guest!

MOSS Forum

Home » Forum » MOSS

Ask a question

RSS Feeds

Error in displaying the Report on sharepoint site, from sql server 2005

Asked By: Salina Sharpe Date: Sep 30, 2008 Category: MOSS Views: 214

I have tried to display reports in Sharepoint sites using SSRS. I have installed SQL Server 2008 (SP1 also installed), share Point 2007 in same box. In this Sql Server 2008 reporting wizard configured as Sharepoint integration mode.

I have able display the reports in sharepoint site from the Sql Server 2008 which is same box. But I have another machine having Sql server 2005 (which is not configured any reporting server, remote access permissions are enabled) when I try to display the data from that another machine sharepoint site it is showing below error

An error occurred during client rendering.
An error has occurred during report processing.
Cannot create a connection to data source 'Demo3'.
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

But In SQL Business Intelligence studio, I able to see the preview of that report, when I click on sharepoint site it showing error.

Please anyone guide mw the right direction to over this problem.

Tagged:error in displaying the report on sharepoint site from sql server 2005

1 Answer Found

Answer #1 Answered By: Gretchen Stokes Answered On: Sep 30, 2008

Can you explain your server configuration(topology) and how you are trying to connect/use reporting services on the SQL server 2005 box.

Did you install reporting services on the sql server 2005 box which has Basic SharePoint installation? What version of reporting services are you using?

Here are some troubleshooting steps.

Reporting services 2008 : msdn.microsoft.com/en-us/library/ms159135.aspx

Reporting services 2005: http://msdn.microsoft.com/en-us/library/ms159135(SQL.90).aspx

Didn't find what you were looking for? Find more on Error in displaying the Report on sharepoint site, from sql server 2005 Or get search suggestion and latest updates.