We disabled a user, then re-enabled them, and they use Windows auth to login to our SQL server (100+ other users using win auth no problem). I've deleted the user account in SQL overall, removed it from each database, checked that it no longer shows up anywhere, then re-added it, but at every logon attempt of this one user from any PC using SSMS, they receive the following error. I've redacted the name and IP for privacy.
*Login failed for user 'DOMAIN\REDACTED'. (.Net SqlClient Data Provider)
Server Name: REDACTED
Error Number: 18456
Severity: 14
State: 1
Line Number: 65536*
This is the error that shows when I query the login failed table in the SQL database:
Login failed for user 'REDACTED'. Reason: Could not find a login matching the name provided. [CLIENT: REDACTED]
I confirmed the user account is being created by running [select * from master.sys.server_principals] and confirming the account shows up in the table output. I'm definitely creating it as a Windows auth account, not local sql account.