Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Unable to connect to datasource pointing to Dev environment


Unable to connect to datasource pointing to Dev environment

Author
Message
chaithu559
chaithu559
Valued Member
Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)

Group: General Forum Members
Points: 60 Visits: 271
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
Kees Beimans
SSC Journeyman
SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)

Group: General Forum Members
Points: 76 Visits: 229
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search