Help Accessing SQL Security Manager in SQL v6.5

From: Tony Edwards (anonymous_at_discussions.microsoft.com)
Date: 09/23/04 

Date: Thu, 23 Sep 2004 13:20:53 -0700

A developer was "looking" at the SQL Security Manager (we
use NT authentication). Since they exited the utility, no
one else can get into it. I am guessing that they did
something to the admin group that allowed Domain Admins to
get into the SQL Security Manager utility. Logging on
locally, as the administrator, didn't help.
I keep getting the following error:
"This SQL Server does not support Windows NT SQL Server
security stored procedures."

Any ideas would be appreciated.

Relevant Pages

  • Re: Help Accessing SQL Security Manager in SQL v6.5
    ... Loads of existing threads with this error message exist! ... > something to the admin group that allowed Domain Admins to ... > get into the SQL Security Manager utility. ... > "This SQL Server does not support Windows NT SQL Server ...
    (microsoft.public.sqlserver.security)
  • 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)
  • xp_logingrant failure: unable to query sql server security information
    ... sql security manager to grant a local group to sa ... privilege. ... unable to query sql server security ...
    (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)