InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 16:17:51 GMT20http://www.sqlservercentral.com/Forums/Topic1400806-1063-1.aspxHi,Seems to me you suffer the double hop issue; Kerberos not enabled.To solve this[b]Option 1[/b]:Enable Kerberos Authentication see[url=http://download.microsoft.com/download/B/E/1/BE1AABB3-6ED8-4C3C-AF91-448AB733B1AF/SSRSKerberos.docx] http://download.microsoft.com/download/B/E/1/BE1AABB3-6ED8-4C3C-AF91-448AB733B1AF/SSRSKerberos.docx[/url]Less secure and you use a generic account to access the data source[b]Option 2:[/b]In ReportManager modify the dataSource credentials to:'Connect using credentials stored securely in the report server'[b]Optionally [/b]set 'Use as Windows credentials when connecting to the data source'Hopes this helps,Regards KeesWed, 02 Jan 2013 06:44:52 GMTKees Beimanshttp://www.sqlservercentral.com/Forums/Topic1400806-1063-1.aspxHi 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 headsany help would be really appreciatedThanksChaithanya MFri, 28 Dec 2012 00:05:14 GMTchaithu559