无法生成SSPI上下文

Question

将计算机从休眠或连接到VPN中唤醒后，我无法登录到我的本地主机MSSQLServer

management studio中出现以下错误：

Cannot connect to localhost.

===================================

The target principal name is incorrect.  Cannot generate SSPI context. (.Net SqlClient Data Provider)

赢家: 1909 Pro

SqlServer: 15.0.2070.41

域名:否

同一台机器:是的。

在NT服务下运行的MSSQLServer \MSSQLSERVER

已启用命名管道

TCP/IP已启用

身份验证:混合(Management studio以Windows身份验证登录)

SQL Server Browser + SQL Server代理正在运行

它是从11月开始安装的。问题也是从11月开始的。我只是想不出哪里可能是错的。我读了几篇文章，但它们不能工作，或者不能像我一样在同一台机器上运行

编辑: Kerberos输出:日志

18/02/2020 12:27:24 Info: Connect to WMI, \root\cimv2
18/02/2020 12:27:50 Error: Access of User Principal information failed System.DirectoryServices.AccountManagement.PrincipalServerDownException: The server could not be contacted. ---> System.DirectoryServices.Protocols.LdapException: The LDAP server is unavailable.
   at System.DirectoryServices.Protocols.LdapConnection.Connect()
   at System.DirectoryServices.Protocols.LdapConnection.SendRequestHelper(DirectoryRequest request, Int32& messageID)
   at System.DirectoryServices.Protocols.LdapConnection.SendRequest(DirectoryRequest request, TimeSpan requestTimeout)
   at System.DirectoryServices.AccountManagement.PrincipalContext.ReadServerConfig(String serverName, ServerProperties& properties)
   --- End of inner exception stack trace ---
   at System.DirectoryServices.AccountManagement.PrincipalContext.ReadServerConfig(String serverName, ServerProperties& properties)
   at System.DirectoryServices.AccountManagement.PrincipalContext.DoServerVerifyAndPropRetrieval()
   at System.DirectoryServices.AccountManagement.PrincipalContext..ctor(ContextType contextType, String name, String container, ContextOptions options, String userName, String password)
   at System.DirectoryServices.AccountManagement.PrincipalContext..ctor(ContextType contextType, String name)
   at KerberosCM.WMIHelper.TryGetUser(SystemInfo mi, UserPrincipal& user)

Answer 1

转到IIS服务器上的应用程序池，然后转到高级设置确保设置的身份帐户为correct.Also检查您在IIS上设置的帐户，右键单击网站，然后转到管理网站，然后管理网站和高级设置。