Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS Report on Local Server works fine but not through Remote server Expand / Collapse
Author
Message
Posted Monday, May 16, 2011 1:49 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, June 17, 2014 7:24 AM
Points: 283, Visits: 115
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
Posted Monday, May 16, 2011 10:09 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 11:04 AM
Points: 1,254, Visits: 13,552
can you post the errors on remote access??


rfr.ferrari
DBA - SQL Server 2008
MCITP | MCTS

remember is live or suffer twice!
Post #1109553
Posted Monday, May 16, 2011 12:10 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 8:41 AM
Points: 2,818, Visits: 2,553
Did you set up the authentication for the data source on the report server or just in your project?
Post #1109692
Posted Monday, May 16, 2011 10:45 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, June 17, 2014 7:24 AM
Points: 283, Visits: 115
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
Posted Tuesday, May 17, 2011 6:27 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 11:04 AM
Points: 1,254, Visits: 13,552
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
Posted Tuesday, March 5, 2013 3:58 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, March 5, 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 »

Add to briefcase

Permissions Expand / Collapse