Sql Server Reporting Services - Errors and Solutions

Error - 1

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. Check the documentation for more information. (rsReportServerDisabled)

Solution:
Check the microsoft KB article at the following link.
http://support.microsoft.com/kb/842421

Error -2
The permissions granted to user are insufficient for performing this operation. (rsAccessDenied)

Solution:
Apply the permissions to the user as mentioned in the below article.
http://msdn2.microsoft.com/en-us/library/aa337471.aspx
If you are using Team Foundation Server, check the following link.
http://team-foundation-server.blogspot.com/2007/09/permissions-granted-to-user-userid-are.html

SQL Server -- Acronym

• DMX -- Data Mining Extension
• DSV -- Data Source View
• MDF -- Master Data File -- Primary data file for the database in SQL Server.
• MDX -- Multidimensional Expressions
• NDF -- -- Secondary data file for the database.
• OLAP -- Online Analytical Processing
• OLTP -- Online Transaction Processing
• RDL -- Report Definition Language
• SAC -- Surface Area Configuration -- Used to manage Sql Service / features by SQL Server Administrators
• SMDL -- Semantic Data Modeling Language
• T-SQL -- Transact SQL -- Microsoft Proprietary Language for writing SQL statements.
• XMLA --

MS SQL Server 2008 Reporting Services

1. Build reports from different datasources like Sql Server, Oracle, DB2, SAP
2. Business users can create their own reports (ad-hoc reports)
3. Reporting Services Configuration Manager to manage the report configurations.
4. Render reports to different formats (HTML, PDF, XML, Doc, Excel)
5. Integrate reports with SharePoint Server.