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: Today @ 2:55 AM
Points: 1,262, Visits: 13,558
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: Friday, December 12, 2014 8:24 AM
Points: 2,818, Visits: 2,567
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: Today @ 2:55 AM
Points: 1,262, Visits: 13,558
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
Posted Wednesday, September 24, 2014 4:58 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 2:16 PM
Points: 449, Visits: 1,053
Just to note,
I was recently having a similar issue. The test database I was working on gets restored from back up periodically from another machine. So that breaks the Sql Server user on the database mapping to the login on server. Thus I need to re-create the test user account (that I employ on the database ) to match to that of the login on this test server. As an additional step, since I call stored procedure in my reports, I also have to grant the execute permission to that user in that database. So depending on your circumstance you may need to allow access to views and tables if the account you use to connect with in ssrs does not already have read access on the database. Just thought I'd share.
Post #1619524
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse