RE: xp_logingrant failure: unable to query sql server security information

From: linda deng[MS] (lideng@online.microsoft.com)
Date: 12/20/02 

From: lideng@online.microsoft.com (linda deng[MS])
Date: Fri, 20 Dec 2002 08:33:43 GMT

Hi Cindy,

The error message probably pops up when you have revoked sa privileges on
the local Admin group within the current Security Manager session. Also, it
probably indicates that the registry key
(HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\MSSQLServer) permission
for the local Admin group has been set to Read.

For more information, please refer to the following Knowledge Base (KB)
article: INF: How to Troubleshoot SQL Server 6.5 SQL Security Manager
Messages
ID: 164167
(http://support.microsoft.com/default.aspx?scid=KB;EN-US;164167).

HTH.

Sincerely,

Linda Deng
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

Quantcast