RSLogon Failed
HiI've changed the account information my SCE installation is using. Also set the new account info in the various 'RunAs' accounts. SCE seems to work fine, but I now run into problems with reports failing with error messages like this:
Date: 4-2-2009 13:49:08Application: System Center EssentialsApplication Version: 6.0.1885.0Severity: ErrorMessage: Cannot initialize report.
Microsoft.Reporting.WinForms.ReportServerException: Logon failed. (rsLogonFailed) ---> Microsoft.Reporting.WinForms.ReportServerException: For more information about this error navigate to the report server on the local server machine, or enable remote errors --- End of inner exception stack trace --- at Microsoft.Reporting.WinForms.ServerReport.GetExecutionInfo() at Microsoft.Reporting.WinForms.ServerReport.GetParameters() at Microsoft.EnterpriseManagement.Mom.Internal.UI.Reporting.Parameters.ReportParameterBlock.Initialize(ServerReport serverReport) at Microsoft.EnterpriseManagement.Mom.Internal.UI.Console.ReportForm.SetReportJob(Object sender, ConsoleJobEventArgs args)Microsoft.Reporting.WinForms.ReportServerException: For more information about this error navigate to the report server on the local server machine, or enable remote errorsEvent viewer logs an event ID 107:Report Server Windows Service (SCE) cannot connect to the report server database.Seems to be an authentication issue which should be solved by entering the correct account logon details with the Reporting Services Configuration tool, however this tool also generates an error when I connect to the SCE instanceonce the GUI is displayed:There was an error while refreshing the Reporting Services Configuration Manager. The exeption details are:System.Runtime.InteropServices.COMException (0x80040219)at System.Runtime.InteropServices.Marshal.ThrowExecptionForHRInternal(Int32 errorCode, IntPtr errorInfo)etc.After clicking OK GUI shows Server Status as Not Configured. I am unable to select anything on the left window pane, each selection brings up an error:There was an error while switching panels. The most likely cause is an error retrieving WMI properties. The exception details are: <followed by list of arguments similar to the error mentioned above>What can I do to solve this problem ?
February 4th, 2009 4:11pm
Hi,This error could indicate that Report Server Data Source might have a problem. Check it by these steps:1. Run IE and go to "http://localhost/Reports$SCE" if using built-in SQL Express (or "http://localhost/Reports" if you used a dedicated full SQL install).2. Click the "Show Details" button on the far right side of the menu bar in the web page.3. Find two items named Data Warehouse Main and WSUS Database.4. Click each of them to modify the properties, choose "Credentials are not required" under the branch "Connect using".5. Click "Apply" and close the Report Manager.
Free Windows Admin Tool Kit Click here and download it now
February 6th, 2009 1:24pm
Thank you for your answer Eric,Unfortunately I cannot get past item 1 in your procedure: when I try to browse tohttp://localhost/Reports$SCE I get an error: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) (rsRPCError)When trying for a second time (after closing the browser session) I did get a new error:Response is not well-formed XML.It seems none of the tools used to manage the reporting engine functions in the way it should......Any ideas ?Hans
February 9th, 2009 3:07pm
Hi,
Please open your Reporting Service configuration manager, connect to your SCE instance, click "Execution Account" tab, change your passwork and make sure it match the account in SCE.
Free Windows Admin Tool Kit Click here and download it now
February 12th, 2009 2:05pm
Eric,
Unfortunately I cannot select anything in theReporting Service configuration manager. Whenever I try to make a selection in the left window pane I only get an error:There was an error while switching panels. The most likely cause is an error retrieving WMI properties. The exception details are: System.Runtime.InteropServices.COMException (0x80040219)at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCoe, IntPtr errorInfo)at System.Management.ManagementObjectCollection.ManagementObjectEnumerator.MoveNext()at ReportServicesConfigUI.WMIProvider.RSIntances.GetReportSreverAdminInstance(RSInstance rsinstance)at ReportServicesConfigUI.Panels.ConfigurationPanel.get_ServerAdmin()at ReportServicesConfigUI.COnfigurationManager.step.Feedback_Click(Object sender, EventArgs e)
The Report Server's status is 'Not configured' (initialized & service status entries are blank, both Start and Stop buttons are greyed out), Encryption Keys status is 'Optional configuration', Initialization status is greyed out, both Email Settings and Execution Account status is 'Recommended Configuration', all others are marked 'Configured'. Any other ideas or should I plan to remove/reinstall SCE completely?BrgdsHans
February 13th, 2009 10:37am
Hi Hans,I'd like to suggest you re-install the SCE, it will be better if you can re-install SQL reporting service on the same server, please try the following steps to performa a re-installation of your SCE server:1. Un-install SCE from Control Panel - Add/Remove Programes.2. Remove SCE SCP:
a. On the Domain Controller, open ADSI Edit (Start - Run - Adsiedit.msc).
b. Right click on the Domain tree and select New - Query.
c. In the New Query window, enter the following:
Name: SCESCP QueryRoot of Search: <domain name>Query String: (&(objectCategory=serviceConnectionPoint)(cn=SCESCP))
d. Click on OK.
e. Expand the Domain node in ADSI Edit and select the SCESCP Query node.
f. A CN=SCESCP object should be listed in the right-hand pane, with a distinguished name ofCN=SCESCP,CN=<ComputerName>,CN=<OUName>,DC=<DomainName>,DC=com. This tells us which computer account has the SCE SCP.
g. Delete the SCESCP object from the SCESCP Query node in ADSI Edit.3. Delete the key in registry HKLM\SOFTWARE\Microsoft\System Center EssentialsHKLM\SOFTWARE\Microsoft\Microsoft Operations Manager4. Restart the server and perform the fresh installation of SCE
Free Windows Admin Tool Kit Click here and download it now
February 16th, 2009 12:53pm
Hi EricFollowed the steps you mentioned in your post, but the situation grew worse.Tried several scenario's reinstalling SCE but setup fails every time and subsequently any changes to the system are rolled back. SQL install succeeds, SUS install succeeds, third part of SCESetup fails. Log fileSCE0.log shows errors likeGetMsiFeatureState: Failed to get feature state. Error Code: 0x80070646. MOMGatewaySetHealthServiceConfig: Failed to get Feature State.. Error Code: 0x80070646. MOMGatewayGetRegistyStringValue: RegQueryValueEx failed.. Error Code: 0x80070002.GetMsiFeatureState: Failed to get feature state. Error Code: 0x80070646. MOMREPORTINGDBI am installing an Express version of SQL (the one included on the SCE CD) on the same server that should become (and in the past indeed was) the SCE server. Tried to setup just SQL, installation was succesful. When I tried to use the Reporting Services Configuration Tool I got the same errors as stated in my post of February 13th.
Got stuck there ! Hope you can help.....
February 19th, 2009 6:21pm
EricAnysuggestions ? Maybe someone else has a bright idea ?
Free Windows Admin Tool Kit Click here and download it now
February 24th, 2009 4:26pm
Hi,Did you uninstall SRS before you performed tha new installation of SCE?It indicated that the problem is related to SQL reporting service, I'd like to suggest you re-install the SRS if it is possible
March 9th, 2009 1:14pm
Hi EricThanks for your continued support.I'm not sure what you mean with SRS. If SCE Setup finds any SCE related items already installed the first task performed by Setup is removing them.Apart from this I tried removing all SCE/SQL related stuff through add/remove programs as well as disabling all SCE/MOM/SQL related services that were left on the server before I gave setup another try. Still no luck.At the moment I'm considering to restore an old tape (end 2008) in order to get things up and running again. Yes I'm that desparate !
Free Windows Admin Tool Kit Click here and download it now
March 9th, 2009 5:41pm
Run rskeymgmt -d from command prompt Helpful read up : http://msdn.microsoft.com/en-us/library/ms162822.aspx
October 27th, 2009 11:15pm