Windows auth. is much slower than SQL server auth.

  • 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?

  • 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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply