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

Report run on Server not from user machine Expand / Collapse
Author
Message
Posted Friday, April 19, 2013 2:43 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, October 23, 2014 8:18 AM
Points: 152, Visits: 1,165
I'm able to run my Report from Reporting Service on the server it's on but if I or a user try to run it from our desktop we are unable to excute it, we receive:

Cannot create a connection to data source 'DBName'. (rsErrorOpeningConnection)
For more information about this error navigate to the report server on the local server machine, or enable remote errors.
Post #1444614
Posted Friday, April 19, 2013 6:35 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 5:32 PM
Points: 1,796, Visits: 5,801
It sounds like your report's data source is set to use the end user's Windows Credentials to connect to the database and either the user doesn't have permission to do that OR your report manager is using anonymous authentication.

Check the setup of the data source on the report.


MM


  • MMGrid Addin
  • MMNose Addin


  • Forum Etiquette: How to post Reporting Services problems
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • How to Post Performance Problems - by Gail Shaw

  • Post #1444658
    Posted Friday, April 19, 2013 9:15 PM
    SSC-Enthusiastic

    SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

    Group: General Forum Members
    Last Login: Thursday, October 23, 2014 8:18 AM
    Points: 152, Visits: 1,165
    the data source is set for Windows integration.
    Post #1444670
    « Prev Topic | Next Topic »

    Add to briefcase

    Permissions Expand / Collapse