: Check which account is running the SQL Server service. If it's a domain account, ensure the SPN is registered specifically to that account using the command setspn -L .
: This official tool from Microsoft Learn can scan your SQL instance and automatically identify missing or misconfigured SPNs. : Check which account is running the SQL Server service
The error message typically signals a failure in Kerberos authentication between a client and a SQL Server. It usually means the client cannot verify the identity of the server because of a mismatch or issue with the Service Principal Name (SPN) . Common Root Causes which often causes this specific error.
: Run setspn -X to search for any duplicate SPNs in your domain, which often causes this specific error. : Check which account is running the SQL Server service