Windows-Server-2008-R2

SQL Server 的 Kerberos 配置管理器錯誤“無法從系統訪問使用者主體資訊”

  • May 17, 2018

當我啟動用於 SQL Server 的 Kerberos 配置管理器並嘗試連接到它所在的本地電腦時,我收到錯誤消息“用於 SQL Server 的 Kerberos 配置管理器錯誤“無法從系統訪問使用者主體資訊”

Google搜尋返回的結果最少。

http://social.technet.microsoft.com/Forums/en-US/717d6821-f3f4-43a6-8bba-5eb4804df499/unable-to-access-user-principal-information-from-the-system-error-when-trying-to-launch-kerberos?forum=sqltools

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/717d6821-f3f4-43a6-8bba-5eb4804df499/unable-to-access-user-principal-information-from-the-system-error-when-trying-to-launch-kerberos?forum=sqltools

我正在使用單個帳戶在單個域中工作。此系統上的所有使用者都不是孤立的或顯示 GUID 而不是他們的 ID。

我真的很想使用這個工具來幫助解決我的 Reporting Services kerberos 問題。

該工俱生成的日誌顯示以下錯誤:

9/16/2014 11:43:05 AM Info: Connect to WMI, \root\cimv2
9/16/2014 11:43:37 AM Error: Access of system information failed System.Runtime.InteropServices.COMException (0x80070035): The network path was not found.

  at System.DirectoryServices.DirectoryEntry.Bind(Boolean throwIfFail)
  at System.DirectoryServices.DirectoryEntry.Bind()
  at System.DirectoryServices.DirectoryEntry.get_AdsObject()
  at System.DirectoryServices.PropertyValueCollection.PopulateList()
  at System.DirectoryServices.PropertyValueCollection..ctor(DirectoryEntry entry, String propertyName)
  at System.DirectoryServices.PropertyCollection.get_Item(String propertyName)
  at System.DirectoryServices.AccountManagement.SAMStoreCtx.ResolveCrossStoreRefToPrincipal(Object o)
  at System.DirectoryServices.AccountManagement.SAMMembersSet.MoveNextForeign()
  at System.DirectoryServices.AccountManagement.SAMMembersSet.MoveNext()
  at System.DirectoryServices.AccountManagement.FindResultEnumerator`1.MoveNext()
  at System.Linq.Enumerable.Contains[TSource](IEnumerable`1 source, TSource value, IEqualityComparer`1 comparer)
  at KerberosCM.WMIHelper.TryIsUserLocalAdmin(SystemInfo si, UserPrincipal user, Boolean& isLocalAdmin)
9/17/2014 8:36:08 AM Info: Connect to WMI, \root\cimv2
9/17/2014 8:36:10 AM Error: Access of system information failed System.Runtime.InteropServices.COMException (0x80070035): The network path was not found.

  at System.DirectoryServices.DirectoryEntry.Bind(Boolean throwIfFail)
  at System.DirectoryServices.DirectoryEntry.Bind()
  at System.DirectoryServices.DirectoryEntry.get_AdsObject()
  at System.DirectoryServices.PropertyValueCollection.PopulateList()
  at System.DirectoryServices.PropertyValueCollection..ctor(DirectoryEntry entry, String propertyName)
  at System.DirectoryServices.PropertyCollection.get_Item(String propertyName)
  at System.DirectoryServices.AccountManagement.SAMStoreCtx.ResolveCrossStoreRefToPrincipal(Object o)
  at System.DirectoryServices.AccountManagement.SAMMembersSet.MoveNextForeign()
  at System.DirectoryServices.AccountManagement.SAMMembersSet.MoveNext()
  at System.DirectoryServices.AccountManagement.FindResultEnumerator`1.MoveNext()
  at System.Linq.Enumerable.Contains[TSource](IEnumerable`1 source, TSource value, IEqualityComparer`1 comparer)
  at KerberosCM.WMIHelper.TryIsUserLocalAdmin(SystemInfo si, UserPrincipal user, Boolean& isLocalAdmin)

我知道這是一個非常古老的文章,但對於仍然遇到此問題的任何人……我設法通過進入伺服器上的本地管理員組並清除所有顯示為 GUID 的帳戶來解決它。

一旦我這樣做了,我就可以啟動該工具,不填寫伺服器/使用者資訊,然後點擊連接。之後就直接登錄了。

(我知道原始發帖人說他已經檢查過了,但這就是為我解決這個問題的原因)。

我知道這個執行緒很舊,但我遇到了同樣的問題。在我的情況下,遠端系統資料庫服務沒有執行。我發現在某些伺服器上它只是在執行,而在其他伺服器上它顯示自動(觸發啟動),在這兩種情況下我都可以成功使用該工具。如果該服務是手動/禁用等…並且未執行,則會發生此錯誤。

引用自:https://serverfault.com/questions/628964