Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Why the SQL server Report server always failed to connect?

Posted on 2012-08-14
2
Medium Priority
?
1,518 Views
Last Modified: 2012-08-14
This is using a newly-setup MS SQL server 2012 system. After the setup, few SQL services including Reporting service is confirmed running. But, the problem is, whenever trying to access the URL of reportServer > http://sqlserver01/ReportServer, the following error messages appear:

Reporting Services Error
--------------------------------------------------------------------------------
 
The report server cannot decrypt the symmetric key that is used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. (rsReportServerDisabled) Get Online Help
Bad Data. (Exception from HRESULT: 0x80090005)

--------------------------------------------------------------------------------

Does this means that  I have to re-create a new symmetric key again? How to confirm reporing service is working fine?

Thanks in advance.
0
Comment
Question by:MezzutOzil
2 Comments
 
LVL 22

Accepted Solution

by:
Nico Bontenbal earned 1000 total points
ID: 38290976
0
 

Author Closing Comment

by:MezzutOzil
ID: 38295015
ok
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Suggested Courses

580 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