Solved

Sql server Report server Error

Posted on 2014-10-23
1
601 Views
Last Modified: 2014-10-31
Hi,
First im Using SQL server 2014

Reporting Services Configuration Manager

Goto Service Account  -->
   Change Use build in account
   to Use another account
after restart the sql Server reorting services i got this message below.
I try rsactivate
C:\Program Files\Microsoft SQL Server\80\Tools\Binn

rsactivate -r -c "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config"

But its showing rsactivate is not recogninized

Error rsReportServerDisabled: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content and then restart the service.

Can some one help me to solve this issue.thx
0
Comment
Question by:ukerandi
1 Comment
 
LVL 18

Accepted Solution

by:
x-men earned 500 total points
ID: 40402040
the encryption key is paired with the service account, when you change the account, you change the encryption key.

To resolve:
-restore the encryption key for the previous service account
OR
- rebuild your data sources
OR
- configure SSRS with the previous service account
- test the data sources,
- backup encryption key
- configure SSRS with the new service account
- restore encryption key
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Upgrading my SSIS package in VS 2012 6 60
SSRS Deployment problem 5 66
RESTORE A BACKUP IN SQL 2012 from SQL 2008 9 65
xml files 7 29
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

828 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