[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

SQL Server 2005 Report Manager Issue

Posted on 2009-07-07
15
Medium Priority
?
466 Views
Last Modified: 2016-12-08
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?
0
Comment
Question by:rdracer58
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 7
15 Comments
 
LVL 11

Expert Comment

by:dodge20
ID: 24798202
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
 

Author Comment

by:rdracer58
ID: 24798246
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
 
LVL 11

Expert Comment

by:dodge20
ID: 24798332
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
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 

Author Comment

by:rdracer58
ID: 24804349
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
 
LVL 11

Expert Comment

by:dodge20
ID: 24808072
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
 

Author Comment

by:rdracer58
ID: 24808141
Here are the log files.
LogFiles.zip
0
 
LVL 11

Expert Comment

by:dodge20
ID: 24808277
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
 

Author Comment

by:rdracer58
ID: 24813606
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
 
LVL 11

Expert Comment

by:dodge20
ID: 24813733
The encryption key backup is required. It is just a one time backup. I believe this is what is causing your error.
0
 

Author Comment

by:rdracer58
ID: 24813755
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
 
LVL 11

Expert Comment

by:dodge20
ID: 24813819
I would just back it up again to a location where u can find it.
0
 

Author Comment

by:rdracer58
ID: 24813859
Okay - encryption key backed up, however, still experiencing the report server issue. What is the entire process that needs to take place?
0
 
LVL 11

Expert Comment

by:dodge20
ID: 24813883
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
 

Author Comment

by:rdracer58
ID: 24813930
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
 
LVL 11

Accepted Solution

by:
dodge20 earned 2000 total points
ID: 24814004
Check this thread. Appears to be the same issue.

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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question