大网数据广告活动
数据库与应用安全

Kerberos tickets - KRB_AP_ERR_TKT_EXPIRED error in SQL Server

· 52CE 我爱测

This article provides symptoms and resolution for the consistent authentication errors to SQL Server that impact Kerberos tickets.

This article helps you resolve consistent authentication issues that might affect Kerberos tickets.

Kerberos is a protocol that uses secret keys for providing secure authentication for client or server applications. A ticket is issued to a user for successful authentication. Typically, Kerberos tickets have a lifetime of about 10 hours and are renewed automatically.

Symptoms

The Key Distribution Center (KDC) displays a KRB_AP_ERR_TKT_EXPIRED error message that indicates that a service has failed.

Cause

The Kerberos connection fails if a user tries to use an expired ticket for authentication. For more information, see Kerberos authentication troubleshooting guidance.

Resolution

To resolve this error, follow these steps:

  1. Use the KLIST purge command to clear user tickets, or log off and back on, or restart the computer.

  2. Use the KLIST command together with the SSPIClient tool to view and manage Kerberos tickets and service principal names (SPNs), as shown in the following command:

    KLIST GET MSSQLSvc\SQLProd01.contoso.com:1433

More information

Consistent authentication issues in SQL Server

Source: Microsoft Learn / IT Pro troubleshooting by Microsoft and contributors. Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.

资料来源与适用范围

资料来源
Microsoft Learn / IT Pro troubleshooting
适用范围
See source applicability · Source date 03/13/2024
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。