SQL Server 2005 Report Manager Issue

We have an instance of SQL Server 2005 Reporting services and are having issues accessing reports from the report manager. Whenever we run any report from the report manager, even when having correctly setup the data sources, at least to the best of our knowledge, we get the following error message:

An error has occurred during report processing.
Cannot create a connection to data source 'JIRA'.
For more information about this error navigate to the report server on the local server machine, or enable remote errors.

How can we correct this? How can we view/enable remote errors?
rdracer58Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

dodge20Commented:
How are the credentials setup in your data source? My guess is that the user running the report doesn't have the correct permissions (if the data source connection string is correct).
0
rdracer58Author Commented:
The datasource is setup running as "Windows Integrated Security." The user running the reports, in this case, myself, I have more permissions than one needs, however, the report doesn't work on the server. The manager was working and now it is not - what permissions might have changed?
0
dodge20Commented:
in the security tab of the data source - are you listed there or in a group that is listed?

Do you belong to a role (ie, browser, or content manager)?
0
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

rdracer58Author Commented:
I am a member of the "Content Manager" group which is listed on the security tab of the data source. In terms of the report server as a whole, I am in the administrator group on the server which includes Browser, Browser for Microsoft CRM, Content Manager, My Reports, Publisher, Publisher for Microsoft CRM, and Report Builder permissions.
0
dodge20Commented:
Can you check the logs in your C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles directory. Permissions seem fine. Maybe the logs can tell us something else.
0
rdracer58Author Commented:
Here are the log files.
LogFiles.zip
0
dodge20Commented:
I see tons of

The permissions granted to user 'DOMAIN\YourName' are insufficient for performing this operation.

The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database



Is your reporting services encryption key backed up? You do this in the reporting services configuration manager.

Also are you accessing this through http or https? If it is http, make sure the the require secure socket layer (ssl) isn't checked in  the report server virtual directory page.
0
rdracer58Author Commented:
We access the site through http - "require secure socket layer (ssl)" is not checked on the report server virtual directory page.I do not believe that we have specifically backed up the report server encryption key - the entire server it resides on is backed up once a week, however, no specific backups of the encryption key from the report manager itself.
0
dodge20Commented:
The encryption key backup is required. It is just a one time backup. I believe this is what is causing your error.
0
rdracer58Author Commented:
Ok - the report server was setup a long time ago and hence whoever did the setup work probably backed it up, but since then it has been lost. What do we do to correct this?
0
dodge20Commented:
I would just back it up again to a location where u can find it.
0
rdracer58Author Commented:
Okay - encryption key backed up, however, still experiencing the report server issue. What is the entire process that needs to take place?
0
dodge20Commented:
Are you still seeing this message in the error logs?

The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database

If those are gone, then we can try to figure out this message.
The permissions granted to user 'DOMAIN\YourName' are insufficient for performing this operation
0
rdracer58Author Commented:
Appears the encryption key issue is gone. Now the errors I am seeing are along the lines of:

Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'JIRA'. ---> System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
0
dodge20Commented:
Check this thread. Appears to be the same issue.

http://www.experts-exchange.com/Database/Software/CRM/Q_23242435.html
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB Reporting Tools

From novice to tech pro — start learning today.