locked
SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. RRS feed

  • Question

  • Hi,

    We are getting the following error from Event Viewer when we connect to SQL Server 2008 from Linux box to Windows Server 2008.  One user account is working just fine, but the other service account is getting the following error.

    SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed.


    We are thinking it might relate to user rights.  Currently, we are making sure no blocking for the following rights from group/uesr security policies.

    • Act as part of operating system;
    • Log on as a batch job;
    • Log on as a service;
    • Replace a process level token;
    • Bypass  traverse checking;
    • Adjust memory quotas for processes

    Are there additional user rights needed to grant in order to resolve this problem? 

    Thanks.

    Friday, September 2, 2011 1:39 PM