Users time out (or it's very slow) authenticating to SQL Server, but RDP authenticates immediately
3
votes
1
answer
2391
views
The authentication timeouts and slowness happen for both local SQL logins and Windows authentication using AD. Rebooting "masks" the problem for a while, but after 6-8 hours, we see them again.
The whole time, I see high numbers of PREEMPTIVE_OS_AUTHENTICATIONOPS waits.
It can't be strictly an AD or routing issue because authentication happens instantly during RDP login using a domain account, even after many hours or days of uptime.
telnet to the relevant ports on the DC instantly return success, so the ports are open.
I've gone through everything on this page, to no avail:
https://samzsimplesql.wordpress.com/2015/09/01/troubleshooting-connectivity-issues-timeout-error-258-unable-to-complete-login-process-due-to-delay-in-prelogin-response-pre-login-handshake-failed-2/
- SQL Server: 2008 R2 EE 10.50.6560.0
- Windows: 2008 Ent
- AD: 2012 R2
(Yes, I know those are ancient versions, but have no control over that.)
What else can I look at?
EDIT:
There are about 1000 connections (it varies throughout the day). "All" (except for the few from me) logins are from the same domain account.
The problem started last Monday.
There are no errors in the SQL Server error log. This is the only (and there were a lot of them!) message in the DB server's event viewer:
> The description for Event ID 17052 from source MSSQLSERVER cannot be
> found. Either the component that raises this event is not installed on
> your local computer or the installation is corrupted. You can install
> or repair the component on the local computer.
>
> If the event originated on another computer, the display information
> had to be saved with the event.
>
> The following information was included with the event:
>
> Severity: 16 Error:258, OS: 258 [Microsoft][SQL Server Native Client
> 10.0]Shared Memory Provider: Timeout error .
Asked by RonJohn
(694 rep)
Apr 19, 2022, 07:02 PM
Last activity: Mar 12, 2023, 03:05 PM
Last activity: Mar 12, 2023, 03:05 PM