Sign in
 
Home2012Previous VersionsLibraryForumsGallery
System Center TechCenter >
> 
> 
SCE 2007 - Database permissions

Answered SCE 2007 - Database permissions

  • Friday, September 30, 2011 2:18 PM
     
      Has Code
    Sign In to Vote
    0

    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


    • Edited by PetrSSS Friday, September 30, 2011 2:19 PM
    •  
     

All Replies

  • Monday, October 03, 2011 5:56 AM
    Moderator
     
     
    Sign In to Vote
    0

     

    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.
     
  • Monday, October 03, 2011 6:21 AM
     
     
    Sign In to Vote
    0

    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.

     
  • Monday, October 03, 2011 7:01 AM
    Moderator
     
     
    Sign In to Vote
    0

     

    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.
     
  • Monday, October 03, 2011 7:24 AM
     
     
    Sign In to Vote
    0

    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.

     
  • Monday, October 03, 2011 7:59 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

     

    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.
    • Marked As Answer by PetrSSS Monday, October 10, 2011 8:59 AM
    •  
     
  • Tuesday, October 04, 2011 8:39 AM
     
     
    Sign In to Vote
    0

    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.

     
  • Friday, October 07, 2011 6:27 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

     

    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.
     
  • Monday, October 10, 2011 8:59 AM
     
     
    Sign In to Vote
    0

    Hi Nicholas,

    I was on holiday so sorry for delay.

    Thank you for advice problems was solved.

     

    Petr

     

     
  • Monday, October 10, 2011 9:32 AM
    Moderator
     
     
    Sign In to Vote
    0

     

    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.