Very Computer

I am using sql server 6.5 in NT 4 server, I login as sa in
sql security manager to grant a local group to sa
privilege. But I get the error:

xp_logingrant failure: unable to query sql server security
information.

How can I fix it?

Thanks

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.