Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sharepoint 2010 Foundation connection

Status
Not open for further replies.

kaywkay

IS-IT--Management
May 5, 2009
5
US
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?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top