Sign in
 
HomeOnline20132010Other VersionsRelated ProductsLibraryForumsGallery
TechCenter >
> 
> 
"SSPI handshake failed with error code 0x8009030c ..."

Answered "SSPI handshake failed with error code 0x8009030c ..."

  • Tuesday, December 21, 2010 12:25 PM
     
     
    Sign In to Vote
    0

    Hi All,

    Below are the farm configuration.

    • 1 SQL server with SQL 2005 STD edition in windows 2003 server Std 64 bit.
    • 1 Application server and 1 WFE server with SharePoint 2007 Std edition in windows 2003 server STD 64 bit.
    • Configured with AD account and it has local admin rights on 3 servers.

    Issue:

    • Daily morning SQL server is reporting Event ID 17806 error. SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [ IP of Application and WFE servers].
    • During same time SQL server is logging 5788 and 5789 errors. 
    • 5788 error: Attempt to update HOST Service Principal Names (SPNs) of the computer object in Active Directory failed. The updated values were 'HOST/FQDN name of SQL Server' and 'HOST/SQL Server Name'. The following error occurred:
      There are no more endpoints available from the endpoint mapper. 
    • 5789 error: Attempt to update DNS Host Name of the computer object in Active Directory failed. The updated value was 'FQDN Name of SQL server'. The following error occurred:
      There are no more endpoints available from the endpoint mapper. 
    • At the same point Application and WFE servers are getting 27745 error for thousands of time in 2 minutes. As it is early morning we don't know how the sharepoint application is behaving (accessible are not).  From past 2days we are getting these errors. It is happening only for 2 min in the morning.
    • 27745 error : The description for Event ID ( 27745 ) in Source ( Windows SharePoint Services 3 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: #50071: Unable to connect to the database WSS_Content_DB on SQL server.  Check the database connection information and make sure that the database server is running..

    To resolve this found few SPN queries, but didnt tried as it is production environment. Is this issue with SPN name of SQL server?

    how to stop this errors?

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

    Thanks & regards

    V235

     

    • Edited by Mike Walsh FIN Tuesday, December 21, 2010 12:37 PM "Waiting for MS replies." removed from text
    • Edited by Mike Walsh FIN Monday, December 27, 2010 8:34 AM Title far too long. Do not use entire error message as a title
    •  
     

All Replies

  • Tuesday, December 21, 2010 3:27 PM
     
     
    Sign In to Vote
    0

    We had this issue yesterday, its started around 5:25 and finished 5:26. But in our case it automatically fixed. in our case our whole farm went down for a min then came back after investigation we found its due to AD problem. AD server was not able to authenticate the windows account for a moment.

    we see bunch of unable to connect database.

     

    thanks

    -ws

    SharePoint administrator, MCTS,MCITP
     
  • Wednesday, December 22, 2010 8:40 AM
     
     Answered
    Sign In to Vote
    0

    Hi,

    Thanks to share your post in this forum.

    For the issue that you have encountered, if your local asp.net site is running under iis, then you need to set to
    run under a domain account with access the SQL server.

    1) If you only hit the website locally just set impersonate=true in the
    web config and require authentication to ntlm in iis.

    2) If your local box is vista or server2003 set the app pool for the
    asp.net site to the desired domain account.

    3) If none of above, in web.config set impersonate with a username and
    password.

    And some other useful references:

    http://www.associatedcontent.com/article/5725578/techtips_how_to_fix_the_error_sspi.html.

    http://msdn.microsoft.com/en-us/library/ms998320.aspx.

    http://www.bigresource.com/Tracker/Track-ms_sql-HDpysQ7v/.

    Hope this could help you!

    Leo

    • Marked As Answer by Mike Walsh FIN Monday, December 27, 2010 8:35 AM
    •  
     
  • Wednesday, December 22, 2010 8:41 AM
     
     
    Sign In to Vote
    0

    Hi ,

    In my case also, it fixed automatically. we got this for two days at 4:45AM to 4:46AM. Today there is no such errors.

    Are you able to get the information which caused this?

     

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

    Thanks & Regards

    V235

    • Edited by Mike Walsh FIN Monday, December 27, 2010 8:34 AM Use English in posts. Do not text.
    •  
     
  • Monday, December 27, 2010 8:26 AM
     
     
    Sign In to Vote
    0

    Hi,

    Thanks to follow up your post in this forum.

    For the issue, I think it may due to the communications with AD and also your server is not properly recognized. And some other reason may be your SQL server credentials error.

    Hope it helps!

    Leo