Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 3 replies
  • Subscribers 1 subscriber
  • Views 2458 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

Cannot Generate SSPI Context

SamT

Hi,

After a server - Windows 2008 R2 restart. For some reason, i can't start Enterprise Console for sophos anymore.

I've checked the event viewer and got this error.

Step: Creating a database connection 

Error: std::runtime_error

Data: Cannot generate SSPI context.

I've went to the troubleshooting exercise suggested on http://www.sophos.com/support/knowledgebase/article/66028.html

Everything steps were success until Step 7.4 .  Didn't work.

Tried stop and start up the SQL Server (SOPHOS) and changing the Log On credential - either LocalSystem or Domain\User, both worked

But still i can't start up Enterprise Console.

Help anyone ?

:24047


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

    Hi,

    The fact you mention problems occured after a restart, does:

    http://blog.paulgu.com/database/cannot-generate-sspi-context/

    apply?

    I assume you are using a domain account for the "database" account, referenced under:?
    HKEY_LOCAL_MACHINE\SOFTWARE\[wow6432node]\Sophos\EE\Management Tools\DatabaseUser \

    If so, you could test logging on to the machine as that account, creating a file called "test.udl", launch it and fill in the details:
     

    Provider: "Microsoft OLE DB Provider for SQL Server"
    Connection tab: Enter the Server and instance name. E.g. [servername]\SOPHOS

    Select: "Use Windows NT Intergrated security".

    Try and choose the Sophos database (Sophos50 for SEC 5 for example) from the drop down

    Does this test work? 

    Regards,

    Jak

    :24083
Reply
  • 0

    Hi,

    The fact you mention problems occured after a restart, does:

    http://blog.paulgu.com/database/cannot-generate-sspi-context/

    apply?

    I assume you are using a domain account for the "database" account, referenced under:?
    HKEY_LOCAL_MACHINE\SOFTWARE\[wow6432node]\Sophos\EE\Management Tools\DatabaseUser \

    If so, you could test logging on to the machine as that account, creating a file called "test.udl", launch it and fill in the details:
     

    Provider: "Microsoft OLE DB Provider for SQL Server"
    Connection tab: Enter the Server and instance name. E.g. [servername]\SOPHOS

    Select: "Use Windows NT Intergrated security".

    Try and choose the Sophos database (Sophos50 for SEC 5 for example) from the drop down

    Does this test work? 

    Regards,

    Jak

    :24083
Children
No Data