Report run on Server not from user machine

• kd11

  Hall of Fame

  Points: 3447

  More actions

  April 19, 2013 at 2:43 pm

  #274185

  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.

• mister.magoo

  SSC-Forever

  Points: 47068

  More actions

  April 19, 2013 at 6:35 pm

  #1608436

  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
[/url]
• Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]
• How to Post Performance Problems - by Gail Shaw
[/url]