SPN The target principal name is incorrect. Cannot generate SSPI context. ( SPN ) 현상 The target principal name is incorrect. Cannot generate SSPI context. (Microsoft SQL Server, Error: 0) SSMS를 통해 host 명으로 Windows 인증으로 접속하려 할 때 위와 같은 에러가 발생하는 경우입니다. 로그 분석 xp_readerrorlog 로 로그를 확인한 결과 The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/xxxxxx ] for the SQL Server service. Windows return code: 0x2098, state: 15. Failure to reg.. 운영/기타 2022. 5. 20. Register a SPN for SQL Server Authentication with Kerberos https://www.mssqltips.com/sqlservertip/2955/register-a-spn-for-sql-server-authentication-with-kerberos/ Register a SPN for SQL Server Authentication with Kerberos After querying the SQL Server sys.dm_exec_connections DMV I noticed that all my currently connected sessions using Windows Authentication had used NTLM and not Kerberos. How do I get them to use Kerberos? Check out this tip to learn mo.. 운영/권한 관리 2021. 5. 18. 이전 1 다음
