Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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 Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 19, 2016 11:20 AM
Points: 207, Visits: 1,451
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


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 5:31 PM
Points: 2,147, Visits: 7,498
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


select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);


  • 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 Veteran

    SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

    Group: General Forum Members
    Last Login: Tuesday, July 19, 2016 11:20 AM
    Points: 207, Visits: 1,451
    the data source is set for Windows integration.
    Post #1444670
    « Prev Topic | Next Topic »

    Add to briefcase

    Permissions Expand / Collapse