Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 2 replies
  • Subscribers 1 subscriber
  • Views 3754 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Sophos Compliance Agent Results - Error Reporting Results

mbjoe

After installing the NAC Agent on about five machines this morning, I received a "Sophos Compliance Agent Results" windows on two of them when logging in. The errors displayed are below. It works on three of the five.... only two generated the messages:

The agent does not have a policy to assess. If this problem persists, contact your administrator to report the problem.

--------------------------------------------------------------------------------

The agent was unable to perform the retrieve policy operation. If this problem persists, please contact your administrator to report the problem. (Reason Unknown)

--------------------------------------------------------------------------------

The agent was unable to report results. If this problem persists, contact your administrator to report the problem. (Reason Unknown)

:12461


This thread was automatically locked due to age.
Parents
  • 0

    Checking Sophos NAC server itself, I found an error in the Event Log and I'm not sure if it is related or not. There is a daily event in Task Scheduler called Sophos NAC - LoadWH. It runs at 2:30 everyday using the LOCALSERVER\SophosNAC account. The errors reporting from that are below:

    Log Name:      Application
    Source:        Sophos NAC
    Date:          4/29/2011 11:19:11 AM
    Event ID:      12000
    Task Category: 12
    Level:         Error
    Keywords:      Classic
    User:          N/A
    Computer:      SERVER.DOMAIN.com
    Description:
    PID 8744 : TID 1
    A critical error was encountered!
    -- System Exception Details --
    Message: Cannot open database "GeneralStore" requested by the login. The login failed.
    Type: OleDbException
    Source: Microsoft OLE DB Provider for SQL Server
    Target: Void .ctor(System.Data.OleDb.OleDbConnectionString, System.Data.OleDb.OleDbConnection)
    Stack Trace:
     System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
     System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
     System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
     System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
     System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
     System.Data.OleDb.OleDbConnection.Open()
     SQLTasks.SQLTasksMain.ReportStatus(Boolean status,

    ================================

    Log Name:      Application
    Source:        Sophos NAC
    Date:          4/29/2011 11:19:11 AM
    Event ID:      12000
    Task Category: 12
    Level:         Error
    Keywords:      Classic
    User:          N/A
    Computer:      SERVER.DOMAIN.com
    Description:
    PID 8744 : TID 1
    A critical error was encountered!
    -- Sophos NAC Exception Details --
    Source Message: Failed running step!
    Source: SQLTasks
    Source Timestamp: 4/29/2011 11:19:11 AM
    Source Machine: SERVER
    Source Exception Type: Sophos.NAC.Core.ExceptionManagement.EndForceException
    Source: SQLTasks
    Target: Void ProcessSQLTaskList(SQLTasks.SQLTaskList)
    Source App Domain: SQLTasks.exe
    Source Thread Id: 1
    Source Thread Identity:
    Source Win Identity: SERVER\SophosNAC
    Help Link:
    Source Stack Trace:

    --Runtime Evidence--
    Step: Aquiring lock on database connection: ReportStore
    TaskDB: none
    TaskSP: none
      -- System Exception Details --(Contained Exception)
      Message: Cannot open database "ReportStore" requested by the login. The login failed.
      Type: OleDbException
      Source: Microsoft OLE DB Provider for SQL Server
      Target: Void .ctor(System.Data.OleDb.OleDbConnectionString, System.Data.OleDb.OleDbConnection)
      Stack Trace:
       System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
       System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
       System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
       System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
       System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
       System.Data.OleDb.OleDbConnection.Open()
       SQLTasks.EfDbConnection.get_DbConnection()
       SQLTasks.Settings.get_LockDBConnection()
       SQLTasks.SQLTasksMain.ProcessSQLTaskList(SQLTaskList list)

    :12463
Reply
  • 0

    Checking Sophos NAC server itself, I found an error in the Event Log and I'm not sure if it is related or not. There is a daily event in Task Scheduler called Sophos NAC - LoadWH. It runs at 2:30 everyday using the LOCALSERVER\SophosNAC account. The errors reporting from that are below:

    Log Name:      Application
    Source:        Sophos NAC
    Date:          4/29/2011 11:19:11 AM
    Event ID:      12000
    Task Category: 12
    Level:         Error
    Keywords:      Classic
    User:          N/A
    Computer:      SERVER.DOMAIN.com
    Description:
    PID 8744 : TID 1
    A critical error was encountered!
    -- System Exception Details --
    Message: Cannot open database "GeneralStore" requested by the login. The login failed.
    Type: OleDbException
    Source: Microsoft OLE DB Provider for SQL Server
    Target: Void .ctor(System.Data.OleDb.OleDbConnectionString, System.Data.OleDb.OleDbConnection)
    Stack Trace:
     System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
     System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
     System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
     System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
     System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
     System.Data.OleDb.OleDbConnection.Open()
     SQLTasks.SQLTasksMain.ReportStatus(Boolean status,

    ================================

    Log Name:      Application
    Source:        Sophos NAC
    Date:          4/29/2011 11:19:11 AM
    Event ID:      12000
    Task Category: 12
    Level:         Error
    Keywords:      Classic
    User:          N/A
    Computer:      SERVER.DOMAIN.com
    Description:
    PID 8744 : TID 1
    A critical error was encountered!
    -- Sophos NAC Exception Details --
    Source Message: Failed running step!
    Source: SQLTasks
    Source Timestamp: 4/29/2011 11:19:11 AM
    Source Machine: SERVER
    Source Exception Type: Sophos.NAC.Core.ExceptionManagement.EndForceException
    Source: SQLTasks
    Target: Void ProcessSQLTaskList(SQLTasks.SQLTaskList)
    Source App Domain: SQLTasks.exe
    Source Thread Id: 1
    Source Thread Identity:
    Source Win Identity: SERVER\SophosNAC
    Help Link:
    Source Stack Trace:

    --Runtime Evidence--
    Step: Aquiring lock on database connection: ReportStore
    TaskDB: none
    TaskSP: none
      -- System Exception Details --(Contained Exception)
      Message: Cannot open database "ReportStore" requested by the login. The login failed.
      Type: OleDbException
      Source: Microsoft OLE DB Provider for SQL Server
      Target: Void .ctor(System.Data.OleDb.OleDbConnectionString, System.Data.OleDb.OleDbConnection)
      Stack Trace:
       System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
       System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
       System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
       System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
       System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
       System.Data.OleDb.OleDbConnection.Open()
       SQLTasks.EfDbConnection.get_DbConnection()
       SQLTasks.Settings.get_LockDBConnection()
       SQLTasks.SQLTasksMain.ProcessSQLTaskList(SQLTaskList list)

    :12463
Children
No Data
Unfiltered HTML