Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 2 replies
  • Subscribers 1 subscriber
  • Views 3750 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.
  • 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
  • 0

    I've found some more interesting things that may help pinpoint what our problem is.... but I still cannot get the agents to talk with the server.

    On the server running SophosNAC there is SQL Server database service named SQL Server Agent (SOPHOS) that is stopped and has apparantly been stopped for awhile now. I cannot get the service to start, when I try to start it up it fails... I also noticed the Prcoess ID associated with the service is 0 while others have specific numbers.

    :12465
Unfiltered HTML