Unable to connect to datasource pointing to Dev environment

• chaithu559

  SSCommitted

  Points: 1574

  More actions

  December 28, 2012 at 12:05 am

  #286804

  Hi All,

  I have a strange issue with SSRS 2005 , The issue is the report works fine from BIDS , but not from the Report Manager.

  Envirnoment Details

  --------------------

  1. Report Manager is in server 'A'

  2. Report Databases are in server 'B'

  3. the server i am trying to connect is a different server , say 'C'

  So, the data source which i have in my report is pointing to a database in server instance 'C'

  the error i get in the report manager when i view it is :

  "An error has occurred during report processing.

  Cannot create a connection to data source 'ElektraRep'.

  For more information about this error navigate to the report server on the local server machine, or enable remote errors "

  My try outs

  --------------

  1. i am able to login to the server and to the database with my logins(which i have used for the report) from SSMS.

  2.Unable to connect to the server instace (Dev env) from the server , where i have report server.

  How would i troubleshoot, breaking my heads

  any help would be really appreciated

  Thanks

  Chaithanya M

• Kees Beimans

  SSC Eights!

  Points: 978

  More actions

  January 2, 2013 at 6:44 am

  #1572859

  Hi,

  Seems to me you suffer the double hop issue; Kerberos not enabled.

  To solve this

  Option 1:

  Enable Kerberos Authentication

  see http://download.microsoft.com/download/B/E/1/BE1AABB3-6ED8-4C3C-AF91-448AB733B1AF/SSRSKerberos.docx%5B/url%5D

  Less secure and you use a generic account to access the data source

  Option 2:

  In ReportManager modify the dataSource credentials to:

  'Connect using credentials stored securely in the report server'

  Optionally set 'Use as Windows credentials when connecting to the data source'

  Hopes this helps,

  Regards Kees