Reporting error
Hi. I'm just upgraded my WSUS server to SCE2007 SP1. I got this error: Date: 14.04.2009 10:42:15 Application: System Center Essentials Application Version: 6.0.1885.0 Severity: Error Message: Cannot initialize report. Microsoft.Reporting.WinForms.ReportServerException: An error has occurred during report processing. (rsProcessingAborted) ---> Microsoft.Reporting.WinForms.ReportServerException: Cannot create a connection to data source 'WSUSDatabase'. (rsErrorOpeningConnection) ---> Microsoft.Reporting.WinForms.ReportServerException: The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) --- End of inner exception stack trace --- --- 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: Cannot create a connection to data source 'WSUSDatabase'. (rsErrorOpeningConnection) ---> Microsoft.Reporting.WinForms.ReportServerException: The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) --- End of inner exception stack trace --- Microsoft.Reporting.WinForms.ReportServerException: The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)
April 14th, 2009 2:52am

Hi,First of all, thank you.I followed steps described in part 8 of FAQ, but the error is still exists. I didn't find key WmsdeInstalled in HKLM\SOFTWARE\Microsoft\Update Services\Server\Setup\, but i created REG_DWORD key with value of 0. Now i'm trying to run Essentials Reports called "Hardware inventory" and ihave this error: Date: 16.04.2009 12:17:02Application: System Center EssentialsApplication Version: 6.0.1885.0Severity: ErrorMessage: Cannot initialize report. Microsoft.Reporting.WinForms.ReportServerException: An error has occurred during report processing. (rsProcessingAborted) ---> Microsoft.Reporting.WinForms.ReportServerException: Cannot create a connection to data source 'WSUSDatabase'. (rsErrorOpeningConnection) ---> Microsoft.Reporting.WinForms.ReportServerException: Cannot open database "SUSDB" requested by the login. The login failed.Login failed for user 'DOMAIN\Admininstrator'. --- End of inner exception stack trace --- --- 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: Cannot create a connection to data source 'WSUSDatabase'. (rsErrorOpeningConnection) ---> Microsoft.Reporting.WinForms.ReportServerException: Cannot open database "SUSDB" requested by the login. The login failed.Login failed for user 'DOMAIN\Administrator'. --- End of inner exception stack trace ---Microsoft.Reporting.WinForms.ReportServerException: Cannot open database "SUSDB" requested by the login. The login failed.Login failed for user 'DOMAIN\Administrator'.Using SQL Server Management Studio Express connecting to %computername%\SCE i can see succesfully attached SUSDB database, so it looks fine but still errors.
Free Windows Admin Tool Kit Click here and download it now
April 16th, 2009 4:24am

Hello AVinogradov,If this issue still exist,did youre-install the SCE server on a fresh-installed Windows 2003 Server? This will avoid most of the errors about SUSDB.Thanks,Yog Li - MSFT
April 22nd, 2009 6:25am

Hello Yog Li, I have production SCE (upgraded from WSUS). Is it possible to use the product without a reinstall on a clean system? Why upgrade from WSUS to SCE available if it doesn't work? Such errors indicate that the product is under beta. Thanks.
Free Windows Admin Tool Kit Click here and download it now
April 24th, 2009 8:34am

Hi AVinogradov,You may contact CSS to start a case to resolve this issue. Microsoft System Center Essentials 2007 https://support.microsoft.com/oas/default.aspx?&c1=508&gprid=12684 Hope it helps.Yog Li - MSFT
April 28th, 2009 7:53am

Hello AVinogradov,Thanks for using SCE. And you canpurchase your System Center Essentials licenses from the link below:http://www.microsoft.com/Systemcenter/essentials/en/us/how-to-buy.aspxThanks,Yog Li - MSFT
Free Windows Admin Tool Kit Click here and download it now
April 30th, 2009 5:34am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics