All, I have created some reports in SSRS 2008 and after that deployed it successfully to RM. But when I log in through Repor manager URL, no content is displayed over there on Home page even if it showed report deployed successfully from VS. To me it seems dont have sufficient privileges even if i am admin on my machine. Any idea? T

Can you see settings, in top right most corner, it meas you have acess, are you sure you have deployed to the same URL, Gaurav Gupta http://sqlservermsbiblog.blogspot.com/

Hi Gaurav, Settings is not displayed at top right most corner. I can see only these options over there:- Home, My Subscriptions, Help No other contents are displayed. And I am deploying to the same URL as is listed in Report Configuration Manager. i.e. http://myPCname/ReportServer However, from VS it is displaying that it Deployed Successfully, only if I start VS using "Run as Administrator" otherwise it is complaining that I dont have sufficient privilege. To me it seems, for report manager also it is having access problem. You know anything I can run Report Manager as an admin. Any special setting for it? T

Hi Gaurav, Settings is not displayed at top right most corner. I can see only these options over there:- Home, My Subscriptions, Help No other contents are displayed. And I am deploying to the same URL as is listed in Report Configuration Manager. i.e. http://myPCname/ReportServer However, from VS it is displaying that it Deployed Successfully, only if I start VS using "Run as Administrator" otherwise it is complaining that I dont have sufficient privilege. To me it seems, for report manager also it is having access problem. You know anything I can run Report Manager as an admin. Any special setting for it? T

Hi Gaurav, Settings is not displayed at top right most corner. I can see only these options over there:- Home, My Subscriptions, Help No other contents are displayed. And I am deploying to the same URL as is listed in Report Configuration Manager. i.e. http://myPCname/ReportServer However, from VS it is displaying that it Deployed Successfully, only if I start VS using "Run as Administrator" otherwise it is complaining that I dont have sufficient privilege. To me it seems, for report manager also it is having access problem. You know anything I can run Report Manager as an admin. Any special setting for it? T

From some online help I saw as a solution to change the service account of reporting service to "Local System" which was in my case earlier Local Service. So, I changed it to "Local System" Restarted the SSRS service and tried using VS but I am getting the below error now:- 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 Any idea, what is going wrong.? -T

From some online help I saw as a solution to change the service account of reporting service to "Local System" which was in my case earlier Local Service. So, I changed it to "Local System" Restarted the SSRS service and tried using VS but I am getting the below error now:- 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 Any idea, what is going wrong.? -T

From some online help I saw as a solution to change the service account of reporting service to "Local System" which was in my case earlier Local Service. So, I changed it to "Local System" Restarted the SSRS service and tried using VS but I am getting the below error now:- 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 Any idea, what is going wrong.? -T

I think I made a mistake changing it from Local Service to Local System. (while again change it back to the Local Service account it is asking for some system password which I dont have.) Now I am not able to even deploy the report. Getting the above mentioned error in both VS and Report Manager:- 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) Please guide me to the correct path if anyone has idea about it. Thanks, T

I think I made a mistake changing it from Local Service to Local System. (while again change it back to the Local Service account it is asking for some system password which I dont have.) Now I am not able to even deploy the report. Getting the above mentioned error in both VS and Report Manager:- 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) Please guide me to the correct path if anyone has idea about it. Thanks, T

I think I made a mistake changing it from Local Service to Local System. (while again change it back to the Local Service account it is asking for some system password which I dont have.) Now I am not able to even deploy the report. Getting the above mentioned error in both VS and Report Manager:- 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) Please guide me to the correct path if anyone has idea about it. Thanks, T

Below is detailed error text:- TITLE: Microsoft SQL Server Management Studio ------------------------------ Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: 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) (Report Services SOAP Proxy Source) For help, click: http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsReportServerDisabled&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=10.0.1600.22 ------------------------------ 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) (ReportingServicesLibrary) For help, click: http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsReportServerDisabled&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=10.0.1600.22 ------------------------------ Bad Data. (Exception from HRESULT: 0x80090005) () (mscorlib) ------------------------------ BUTTONS: OK ------------------------------

Below is detailed error text:- TITLE: Microsoft SQL Server Management Studio ------------------------------ Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: 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) (Report Services SOAP Proxy Source) For help, click: http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsReportServerDisabled&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=10.0.1600.22 ------------------------------ 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) (ReportingServicesLibrary) For help, click: http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsReportServerDisabled&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=10.0.1600.22 ------------------------------ Bad Data. (Exception from HRESULT: 0x80090005) () (mscorlib) ------------------------------ BUTTONS: OK ------------------------------

Below is detailed error text:- TITLE: Microsoft SQL Server Management Studio ------------------------------ Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: 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) (Report Services SOAP Proxy Source) For help, click: http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsReportServerDisabled&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=10.0.1600.22 ------------------------------ 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) (ReportingServicesLibrary) For help, click: http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsReportServerDisabled&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=10.0.1600.22 ------------------------------ Bad Data. (Exception from HRESULT: 0x80090005) () (mscorlib) ------------------------------ BUTTONS: OK ------------------------------

Hi Gaurav, I was able to get rid of the above mentioned error by deleting encryption keys from report configuration manager. But am back to the same original problem as in the very first post. (you can ignore the other posts by me stating about the above error) The original problem is still there- in Report Manager it is not displaying any contents. Do you have any suggestions for the same? T

Hi Gaurav, I was able to get rid of the above mentioned error by deleting encryption keys from report configuration manager. But am back to the same original problem as in the very first post. (you can ignore the other posts by me stating about the above error) The original problem is still there- in Report Manager it is not displaying any contents. Do you have any suggestions for the same? T

Hi T, Please run the Internet Explorer as administrator to resolve the issue. This issue is due to User Account Control(UAC) in Microsoft Windows Server 2008, Microsoft Windows Server 2008 R2, Microsoft Windows Vista and Microsoft Windows 7. Or, please follow the article below to solve the issue: How to: Configure a Report Server for Local Administration on Windows Vista and Windows Server 2008 (UAC): http://msdn.microsoft.com/en-us/library/bb630430.aspx If you have any more questions, please feel free to ask. Thanks, Jin ChenJin Chen - MSFT

Hi Jin, I tried running IE as an admin, but issue is still there..i.e., no content displaying in report manager... And am using Windows 7 and i tried running report manager on Internet Explorer 8. -T

Hi T, Could you please try to access the report server(Web Service URL)? And check what happen. Thanks, Jin Chen Jin Chen - MSFT

Hi Jin, The above article link you gave is for Vista and Windows Server 2008. Do you have similar for Windows 7 : how to configure local report server administration on Windows 7. I also tried to disable User Account Control (UAC) but that also didn/t help. Thanks, T

Upon using Web Service URL it gives an error, below:- Reporting Services Error The permissions granted to user 'TEJ-PC\TEJ' are insufficient for performing this operation. (rsAccessDenied) Get Online Help

Hi T, The last message "The permissions granted to user 'TEJ-PC\TEJ' are insufficient for performing this operation" you posted is generally caused by UAC or the account are insufficient for accessing the report server. So, please try to fix the issue in this way: Logon the report server machine with a local administrator account(By default, the local administrators are the content manager in the report server). Run IE as administrator. Open the Report Manager. This time, you may be able to see the "Site Settings" and "Properties" Click "Site Settings" to add "TEJ" as a content manager. Click "Properties" to add "TEJ" as a Content Manager too. Thanks, Jin Chenj Jin Chen - MSFT

Hi Jin, Everything is on my local computer only. i.e. no separate report server on diff machine. all is on one machine only report server , manager , VS etc. And I am having admin rights only on my machine. So, in above steps given by you, opening report manager from IE (run as an admin) still does not display "Site Settings" and "Properties" because effectively we haven/t done anything i.e. changing of any settings so its the same issue existing still there. -T

any idea on that?

Hi T, Had you even removed the local administrators from the Report Server? If there is no default "System Administrators" in the Report Server, we will no longer able to manager the report server, unless we have added another account to the Report Server as "System Administrators". Now, please try to use the SQL Server Management Studio(SSMS) to connect to the Report Server, and check what happens. Also, please check if any error in the Report Server error logs. Thanks, Jin ChenJin Chen - MSFT

HI Jin, I think you misinterpreted my last post. Firstly, I have not removed anything (i.e. local administrators) from the report server. Secondly, using SSMS I am able to connect to the Reporting Services. Therein, under Security folder "Roles" and "System Roles" folders are displayed. But I am not able to add any New Role in this folders. for ex., right click-> Content Manager role -> New Role option is disabled. And same thing for all other roles. This forced me to think of below possibility. --About SQL 2008 installation that I have on my laptop. I have downloaded it from Microsoft Dreamspark website (SQL Server 2008 : Developer Edition) Do you think because of this installation I have restricted access to Reporting Services (i.e. Report Manager) I am not sure but now I can think of this possibility as well. What do you think? -T

Hi T, Do you have any other local administrator account? If so, could you please try to the other account? Thanks, Jin ChenJin Chen - MSFT

Hi Jin, I have only one account on my name as administrator. Don't have any other account for the same. Also, you think this issue could be because of Developer Edition of SQL 2008 as I mentioned in last post. Thanks, T

Hi T, As far as I know, there is not version limitation in this case. Could you please give me remote controls over your computer? If so, I can open an EA session(a Microsoft remote suppot technial) for you. Thanks, Jin ChenJin Chen - MSFT

ok, what kind of info will u need for remote? Let me know pls. -T

Hi T, Could you please give me your EMail address? I will send you a mail about how to connect to a EA session. Thanks, Jin ChenJin Chen - MSFT

Hi Jin, For this issue, you can send me an email to: tej3as@hotmail.com Will reply back to you upon receipt. -T

Hi T, Based on the live session, we can know the issue is caused by RSWindowsNegotiate authentication. RSWindowsNegotiate may require a valid Service Principl Name(SPN), however, in this case, the server is an a workgroup, no SPN valid. That is why the issue occurred. To solve the issue, please comment the <RSWindowsNegotiate/> from the rsreprotserver.config. For more information about authentication in SSRS, please see: http://msdn.microsoft.com/en-us/library/cc281253.aspx If you have any more questions, please feel free to ask. Thanks, Jin ChenJin Chen - MSFT

Thanks, marked as an answer. T