?
Solved

Sql server Report server Error

Posted on 2014-10-23
1
Medium Priority
?
630 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
[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
1 Comment
 
LVL 18

Accepted Solution

by:
x-men earned 2000 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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
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 ?
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Suggested Courses

770 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