Unable to connect to datasource pointing to Dev environment

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services 2005 Development » Unable to connect to datasource pointing to...

Unable to connect to datasource pointing to Dev environment

Rate Topic

Display Mode

Topic Options

Author

Message

chaithu559

Posted Friday, December 28, 2012 12:05 AM

Valued Member

Group: General Forum Members
Last Login: Monday, January 21, 2013 10:13 PM
Points: 60, Visits: 259

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

Post #1400806

Kees Beimans

Posted Wednesday, January 02, 2013 6:44 AM

SSC Journeyman

Group: General Forum Members
Last Login: Tuesday, January 08, 2013 4:58 AM
Points: 76, Visits: 228

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

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

Post #1401815

« Prev Topic | Next Topic »

Permissions