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, Please read the question 8 of the FAQ: Frequently Posted Questions and Answers http://social.technet.microsoft.com/forums/en-US/systemcenter/thread/c44515cb-fb8b-4472-a3d4-a17fa6729a03/ Please make sure you followed exactly those steps. By the way, I would suggestreinstalling SCE on a fresh Windows Server 2003.Thanks,Yog Li - MSFT
Free Windows Admin Tool Kit Click here and download it now
April 15th, 2009 3:08am

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.
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
Free Windows Admin Tool Kit Click here and download it now
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.
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
Free Windows Admin Tool Kit Click here and download it now
April 28th, 2009 7:53am

Hi Yog Li, Unfortunately support.microsoft.com works for money only. So, there is no way to use SCE 2007 for 30 days for free, because it is not functional. Thank you anyway.
April 30th, 2009 2:49am

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

Hello AVinogradov, Thanks for using SCE. And you can purchase your System Center Essentials licenses from the link below: http://www.microsoft.com/Systemcenter/essentials/en/us/how-to-buy.aspx Thanks, Yog Li - MSFT lol worst tech support answer ever!!
October 3rd, 2011 11:29am

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

Other recent topics Other recent topics