SSRS Report on Local Server works fine but not through Remote server

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services 2005 Administration » SSRS Report on Local Server works fine but...

SSRS Report on Local Server works fine but not through Remote server

Rate Topic

Display Mode

Topic Options

Author

Message

SG_Explorer

Posted Monday, May 16, 2011 1:49 AM

SSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 24, 2012 5:38 AM
Points: 282, Visits: 103

Hi,

I deployed a SSRS (2005) report on my Report Server and is working fine, but when tried through Remote Server then received the error as:

"Cannot create a connection to data source 'abc'. (rsErrorOpeningConnection)
For more information about this error navigate to the report server on the local server machine, or enable remote errors"

I searched for this issue but no luck to resolve this so far. I'm using Windows Credentials to access this report and having a Sysadmin permissions. I even permit myself as LOG on LOCALLY on the server.

Could someone please share any idea on resolving this issue.

Thanks
Shishir

Post #1109128

rfr.ferrari

Posted Monday, May 16, 2011 10:09 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, May 02, 2013 10:51 AM
Points: 1,219, Visits: 13,507

can you post the errors on remote access??

rfr.ferrari
DBA - SQL Server 2008
MCITP | MCTS

remember is live or suffer twice!

Post #1109553

Daniel Bowlin

Posted Monday, May 16, 2011 12:10 PM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 11:53 AM
Points: 2,672, Visits: 2,416

Did you set up the authentication for the data source on the report server or just in your project?

Post #1109692

SG_Explorer

Posted Monday, May 16, 2011 10:45 PM

SSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 24, 2012 5:38 AM
Points: 282, Visits: 103

Thanks, the error is:
----------------
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'abc'. (rsErrorOpeningConnection)
For more information about this error navigate to the report server on the local server machine, or enable remote errors.
-----------------------------

I'm deploying the report and the Data Source is using Windows Credentials to access this report. When I tried to run the report on local (Srv01) server (http://Srv01\Reports\pages\report.aspx), it works fine but when trying from other server, it gave me this error.

Post #1109944

rfr.ferrari

Posted Tuesday, May 17, 2011 6:27 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, May 02, 2013 10:51 AM
Points: 1,219, Visits: 13,507

in Management Studio, you must be logon on instance of report server and enable the property EnableRemoteErrors to see more details that error.
follow this -> Management Studio -> in screen: Connect to Server, server type: Reporting Services -> locate the server instance in Server Name; after connected, in Object Explorer, right-click in server instance -> properties -> advanced tab -> EnableRemoteErrors set property like TRUE and restart internet browser.

after this procedure, post again the errors.

rfr.ferrari
DBA - SQL Server 2008
MCITP | MCTS

remember is live or suffer twice!

Post #1110130

haitest

Posted Tuesday, March 05, 2013 3:58 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, March 05, 2013 3:59 PM
Points: 1, Visits: 2

I have created ssrs report using vs 2008.
I deployed it. It works fine locally. when i try to access from remote machine its is asking for credentials & not showing the report. Please give your suggestion on this.

Post #1427071

« Prev Topic | Next Topic »

Permissions