Hello, I have problem with SCE 2007. I receive this event after server restart. Failed to store data in the Data Warehouse. Exception 'SqlException': Login failed for user 'xxx'. Which database must have assigned permission for user 'xxx'? Which kind of permission I need for this user? I have MSSQL 2005 Standart. Thank you very much, Petr

Hi, Please check the issue referring to the following methods: Unable to generate Reports on SCOM getting error Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' http://blogs.technet.com/b/sudheesn/archive/2009/07/28/unable-to-generate-reports-on-scom-getting-error-login-failed-for-user-nt-authority-anonymous-logon.aspx SCOM2007 - Login failed for user '<Account name>'. http://blogs.technet.com/b/edwalt/archive/2007/09/27/2060972.aspx How to Move the OperationsManagerDW Database in Operations Manager 2007 http://technet.microsoft.com/en-us/library/cc540368.aspx Please see the steps 8, 9, 10 and 11 under “To move the OperationsManagerDW database” section. OpsMgr security account rights mapping - what accounts need what privileges? http://blogs.technet.com/b/kevinholman/archive/2008/04/15/opsmgr-security-account-rights-mapping-what-accounts-need-what-privileges.aspx If the issue persists, please also check if there is any related error in the Event Log on the server; if so, please let us know the details. Hope this helps. Thanks.Nicholas Li - MSFT Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Hi, Please check the issue referring to the following methods: Unable to generate Reports on SCOM getting error Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' http://blogs.technet.com/b/sudheesn/archive/2009/07/28/unable-to-generate-reports-on-scom-getting-error-login-failed-for-user-nt-authority-anonymous-logon.aspx SCOM2007 - Login failed for user '<Account name>'. http://blogs.technet.com/b/edwalt/archive/2007/09/27/2060972.aspx How to Move the OperationsManagerDW Database in Operations Manager 2007 http://technet.microsoft.com/en-us/library/cc540368.aspx Please see the steps 8, 9, 10 and 11 under “To move the OperationsManagerDW database” section. OpsMgr security account rights mapping - what accounts need what privileges? http://blogs.technet.com/b/kevinholman/archive/2008/04/15/opsmgr-security-account-rights-mapping-what-accounts-need-what-privileges.aspx If the issue persists, please also check if there is any related error in the Event Log on the server; if so, please let us know the details. Hope this helps. Thanks.Nicholas Li - MSFT Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Hi Nicholas, thank you for reply. I tried everything and nothing help me. Which databases are use from SCE? I will try reinstall SCE. Thank you, Petr.

Hi Nicholas, thank you for reply. I tried everything and nothing help me. Which databases are use from SCE? I will try reinstall SCE. Thank you, Petr.

Hi, Thank you for your prompt response. Regarding the SQL Server which System Center Essentials 2007 requires, please see the section “SQL Server Requirements for Deployment” in the following document: System Requirements and Supported Platforms http://technet.microsoft.com/en-us/library/ff730576.aspx Thanks.Nicholas Li - MSFT Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Hi, Thank you for your prompt response. Regarding the SQL Server which System Center Essentials 2007 requires, please see the section “SQL Server Requirements for Deployment” in the following document: System Requirements and Supported Platforms http://technet.microsoft.com/en-us/library/ff730576.aspx Thanks.Nicholas Li - MSFT Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Hi Nicholas, thx for reply. I mean which databases are created at install SCE (OperationsManager, OperationsManagerDW, etc.) not which database server I can use because I try delete it and reinstall SCE. Sorry for my bad English.

Hi Nicholas, thx for reply. I mean which databases are created at install SCE (OperationsManager, OperationsManagerDW, etc.) not which database server I can use because I try delete it and reinstall SCE. Sorry for my bad English.

Hi, I am sorry for misunderstanding. As far as I know, the following databases are created with System Center Essentials 2007 installation: OperationsManager OperationsManagerDW SUSDB If you want to keep the data, please see if the backup and restore method is helpful: Backup and Restore of System Center Essentials http://technet.microsoft.com/en-us/library/ff741753.aspx Thanks. Nicholas Li - MSFT Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Hi Nicholas, thank you for your information and link. Most errors was resolved after reinstall. I have only three errors now: - Source: OpsMgr Root Connector; EventID: 28001 Details: The Root connector received an exception from the Config Service on StateSyncRequest - Source: Health Service Modules; EventID: 10103 Details: In PerfDataSource, could not find counter WSUS: Client Web Service Methods, Web method calls, _total in Snapshot. Unable to submit Performance value. Module will not be unloaded. - Source: Healt Service Modules; EventID: 10103 Details: In PerfDataSource, could not find counter OpsMgr DW Writer Module, Total Error Count, All Instances in Snapshot. Unable to submit Performance value. Module will not be unloaded. Have you some advice for this event? Thank you very much, Petr.

Hi Nicholas, thank you for your information and link. Most errors was resolved after reinstall. I have only three errors now: - Source: OpsMgr Root Connector; EventID: 28001 Details: The Root connector received an exception from the Config Service on StateSyncRequest - Source: Health Service Modules; EventID: 10103 Details: In PerfDataSource, could not find counter WSUS: Client Web Service Methods, Web method calls, _total in Snapshot. Unable to submit Performance value. Module will not be unloaded. - Source: Healt Service Modules; EventID: 10103 Details: In PerfDataSource, could not find counter OpsMgr DW Writer Module, Total Error Count, All Instances in Snapshot. Unable to submit Performance value. Module will not be unloaded. Have you some advice for this event? Thank you very much, Petr.

Hi, Regarding the Events, please try the following on the problematic server: 1. Clear the HealthService queue: 1) Stop System Center Management service. 2) Go to C:\Program Files\System Center Essentials\, and rename the “Health Service State” folder. 3) Restart System Center Management service. 2. Restart the following services: System Center Management service System Center Management Configuration service System Center Data Access service Meanwhile, if you have not upgraded to System Center Essentials 2007 SP1, please apply the update: System Center Essentials 2007 Service Pack 1 (SP1) http://technet.microsoft.com/en-us/systemcenter/essentials/cc304525 System Center Essentials 2007 SP1 Upgrade (x64 & x86) http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=458 Thanks.Nicholas Li - MSFT Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Hi Nicholas, I was on holiday so sorry for delay. Thank you for advice problems was solved. Petr

Hi Nicholas, I was on holiday so sorry for delay. Thank you for advice problems was solved. Petr

Hi Petr, Thank you for your update. I am very glad to know the issue has been resolved. In the future, if you experience any issues regarding our products or if you have any feedbacks, you are welcome to post a new thread in our forum. It is always our pleasure to be of assistance. Thanks again! Wish you happiness during the holidays! Nicholas Li - MSFT Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.