locked
Forefront Client Security / MOM 2005 Permission Issue RRS feed

  • Question

  • We have a 2003 R2 member server on our domain network running a single server
    topology install of FCS. Reqs such as SQL 2005 etc also installed on the same
    server. All databases reside on this server.

    On the surface, everything seems to be working fine however the event viewer
    is filling up with the following warning every 5 minutes:

    SQL Server Scheduled Job 'OnePoint -
    TodayStatisticsUpdateComputersAndAlerts' (0x736BF0110F2315448092B509B5F7F8AD)
    - Status: Failed - Invoked on: 2010-03-16 23:25:00 - Message: The job failed.
    The owner () of job OnePoint - TodayStatisticsUpdateComputersAndAlerts does
    not have server access.

    This seems a permission / SQL permission issue. Can anyone shed any light on
    how to resolve this?

    To aid, I would add the following info:

    We use a single account DOMAIN\FCS-DAS to do everything.
    This is a local admin on the member server.
    Its in the local MOM admins group.
    Its in the local MOM users group.
    Its in the local SC DW DTS & Reader group.

    In SQL server DOMAIN\FCS-DAS hasa public only server role.
    User mapping: OnePoint: db_owner & public, SystemCenterReporting: db_owner &
    public (roles) only.
    Wednesday, March 17, 2010 7:03 PM

Answers

  • ·        Hi,

    ·         

    ·        As this thread has been quiet for a while, we assume that the issue has been resolved. At this time, we will mark it as ‘Answered’.

    ·         

    If the issue still persists and you want to return to this question, please reply this post directly so we will be notified to follow it up. You can also choose to unmark the answer as you wish.

     

    Regards,


    Nick Gu - MSFT
    Tuesday, March 30, 2010 1:11 AM
    Moderator

All replies

  • Hi,

     

    Thank you for the post.

     

    Before going any further, I’d like to know the following:

    1. Do you have received any other error message?

    2. Does the 14-day history report on the FCS console work well?

     

    OnePoint-TodayStatisticsUpdateComputersAndAlerts is default SQL jobs in the MOM database run every five minutes. Please try changing the MOM service logon account to Local System and see if it helps. .

     

    Regards,


    Nick Gu - MSFT
    Thursday, March 25, 2010 5:55 AM
    Moderator
  • ·        Hi,

    ·         

    ·        As this thread has been quiet for a while, we assume that the issue has been resolved. At this time, we will mark it as ‘Answered’.

    ·         

    If the issue still persists and you want to return to this question, please reply this post directly so we will be notified to follow it up. You can also choose to unmark the answer as you wish.

     

    Regards,


    Nick Gu - MSFT
    Tuesday, March 30, 2010 1:11 AM
    Moderator