Windows auth. is much slower than SQL server auth.

• ArnolddG

  SSC-Addicted

  Points: 464

  More actions

  February 29, 2024 at 12:07 pm

  Go to Answer

  #4386995

  Moving around in SSMS when logged on to the SQL server (2019)  with Windows Authentication reacts much slower than logging in with SQL Server Authentication.

  Also, just connecting to the SQL server with Windows Auth. takes about 20 sec to connect, while SQL Server auth. connects within the second. What could be the issue here?

• frederico_fonseca

  SSCoach

  Points: 16215

  More actions

  February 29, 2024 at 1:34 pm

  Answer

  #4387039

  issue is connectivity between your SQL server and your AD domain controllers , and potentially a few more network issues.

  when using Windows Authentication the Server needs to validate with a DC that the client is what they say they are.