sspi handshake failed with error code 0x80090304 on SQL server after updating DC

Ibrahim AlHusari 131 Reputation points
2022-11-16T09:09:44.61+00:00

Dears ,

we have problem that started after we installed windows updates on our DCs in the environment , now when we are trying to connect remotely to sql database server we got the below errors

260866-1.jpg

260857-2.jpg

kindly note that authentication works fine when we connect to the database from sql server itself with same user

regards,

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,690 questions
Active Directory
Active Directory
A set of directory-based technologies included in Windows Server.
5,844 questions

13 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Seeya Xi-MSFT 16,436 Reputation points
    2022-11-17T05:55:14.163+00:00

    Hi @Ibrahim AlHusari ,

    kindly note that authentication works fine when we connect to the database from sql server itself with same user

    Are you using the same Windows authentication method? From your first picture, it seems that there is something wrong with this windows authentication method.
    Please refer to this: https://learn.microsoft.com/en-us/sql/ssms/scripting/sqlcmd-start-the-utility?view=sql-server-ver16

    Best regards
    Seeya Xi

  2. Ibrahim AlHusari 131 Reputation points
    2022-11-21T06:36:17.13+00:00

    Dears ,

    is there any update regarding this issue ?

    thanks a lot

  3. Tanguy Delamare 1 Reputation point
    2022-11-21T16:16:20.437+00:00

    Hello Ibrahim,

    I have exactly the same problem as you. I have a SQL server 2008 on a Windows Server 2003.

    If you find a solution, I'm a taker

    Thanks

  4. Tanguy Delamare 1 Reputation point
    2022-11-21T16:56:15.383+00:00

    Thanks for your feedback

    Unfortunately for me the problem is not fixed.

  5. Seeya Xi-MSFT 16,436 Reputation points
    2022-11-22T09:38:52.947+00:00

    You can add the account “YourDomain\sqlaccount” to “Access this computer from the network” local security policy (secpol.msc) on the SQL Server box and post which we were successfully able to connect to the instance from the application.
    To address the SSPI Handshake failed errors, always review the security logs post enabling Audit Logon events. Security logs would give a good amount of information needed to address this issues.