System Center Essentials 2010 - change ConnectString for WSUS Database for reporting server

jackbenson
jackbenson used Ask the Experts™
on
Hi,

i am playing with System Center Essentials 2010 and need some help.

i installed SCE 2010 (which in turn installed WSUS) on a clean Win 2008 R2 using the embedded SQL Server Express 2008 R2 database.

then i decided, and i think it was a bad idea, to un-install WSUS and re-install it pointing to an instance of SQL Server 2005 that i have licienced on another server.

this all seemed to work fine until i tried to run reports from SCE 2010 and go the following error:

Note:  The following information was gathered when the operation was attempted.  The information may appear cryptic but provides context for the error.  The application will continue to run.

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 'DOMAINNAME\Administrator'.
   --- 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 'DOMAINNAME\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 'DOMAINNAME\Administrator'.


I think this is because i need to update the data source of the WSUS database in SCE 2010 report server. if i go to the following web page on the server that has SCE 2010 installed i can see the incorrect datasource:

http://SceServer/ReportServer_ESSENTIALS?%2fWSUS+Database&rs:Command=GetDataSourceContents

- <DataSourceDefinition>
  <Extension>SQL</Extension>
  <ConnectString>data source=SCESERVER\ESSENTIALS;initial catalog=SUSDB;Integrated Security=SSPI</ConnectString>
  <UseOriginalConnectString>False</UseOriginalConnectString>
  <OriginalConnectStringExpressionBased>False</OriginalConnectStringExpressionBased>
  <CredentialRetrieval>None</CredentialRetrieval>
  <Enabled>True</Enabled>
  </DataSourceDefinition>

I need to know how to update this.

thanks

jack
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
DonNetwork Administrator

Commented:
Could be the type of authentication you are using



http://technet.microsoft.com/en-us/library/cc708473%28WS.10%29.aspx

Regardless of which database software you use, you cannot use SQL authentication. WSUS only supports Windows authentication.
jackbensonDirector

Author

Commented:
i have no issue connecting from Update Services console.

the problem is when the SCE 2010 console tries to access data from the WSUS database.

thanks

jack
Director
Commented:
i re-installed SCE 2010 in the end and problems went away
jackbensonDirector

Author

Commented:
SCE re-isntall requried

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial