xp_logingrant failure: unable to query sql server security information

From: Cindy Huang (chuang@bear.com)
Date: 12/18/02 

From: "Cindy Huang" <chuang@bear.com>
Date: Wed, 18 Dec 2002 09:32:01 -0800

Hi,

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

Relevant Pages

  • Help Accessing SQL Security Manager in v6.5
    ... A developer was "looking" at the SQL Security Manager (we ... use NT authentication). ... something to the admin group that allowed Domain Admins to ... "This SQL Server does not support Windows NT SQL Server ...
    (microsoft.public.sqlserver.tools)
  • Help Accessing SQL Security Manager in SQL v6.5
    ... A developer was "looking" at the SQL Security Manager (we ... use NT authentication). ... something to the admin group that allowed Domain Admins to ... "This SQL Server does not support Windows NT SQL Server ...
    (microsoft.public.sqlserver.security)
  • Integrated Security
    ... using the sql security manager "The sql server does not ... support Windows NT SQL Server security stored procedures. ... Any idea how to fix this. ...
    (microsoft.public.sqlserver.security)
  • Re: Nesting domain groups under local groups
    ... seem to indicate that if I make a local group a member of a role in an SQL ... Server database, a domain user that is a member of a domain group, which is ... groups in SQL Server. ... Microsoft MVP Scripting and ADSI ...
    (microsoft.public.windows.server.active_directory)
  • Microsoft SQL Server Extended Stored Procdure privilege upgrade vulnerabilities (#NISR15002002A)
    ... Extended Stored Procedure Privilege Upgrade ... Microsoft SQL Server 2000 and 7 extends functionality by using extended ... Three particular extended stored procedures contain a ... of three extended stored procedures. ...
    (Bugtraq)