SharePoint 2010 Foundation
Windows Server 2008 r2
Sql Server 2008
all on the same machine.
I can integrate my Reporting services on the Central Admin Config screen successfully (except I had to manuaaly grant permissions to the WSS_WPG membership and WSS_Content)
I can run the SSRS report that was uploaded to a SharePoint folder for a report with a database on the same sql server, but I get an error running an uploaded ssrs report that uses a database on a different sql server. I can run both reports successfully in BIDS and in Report Builder, but cannot connect to the Report Server from either of those (BIDS, Report Builder 2.0). the error I am getting running the SSRS report from Sharepoint is:
The Underlying connection was closed: An unexpected error occurred on a receive. Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. An existing connection was forcibly closed by the remote host.
I don't know where to begin troubleshooting this problem.
Has anyone any ideas for me?
Windows Server 2008 r2
Sql Server 2008
all on the same machine.
I can integrate my Reporting services on the Central Admin Config screen successfully (except I had to manuaaly grant permissions to the WSS_WPG membership and WSS_Content)
I can run the SSRS report that was uploaded to a SharePoint folder for a report with a database on the same sql server, but I get an error running an uploaded ssrs report that uses a database on a different sql server. I can run both reports successfully in BIDS and in Report Builder, but cannot connect to the Report Server from either of those (BIDS, Report Builder 2.0). the error I am getting running the SSRS report from Sharepoint is:
The Underlying connection was closed: An unexpected error occurred on a receive. Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. An existing connection was forcibly closed by the remote host.
I don't know where to begin troubleshooting this problem.
Has anyone any ideas for me?