Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

Security Manager problem in SQL server 6.5

Open SQL security manager for SQL server 6.5,
Enter Server name and try to connect with Server,
enter sa and password, but it give me an error
" This SQL Server does not support window NT SQL Server Security stored procedure"
Any one knows what is the problem, and how to correct it?
Thanks.
[311 byte] By [Helen] at [2007-11-9 21:09:27]
# 1 Re: Security Manager problem in SQL server 6.5
Is your SQL Server setup for Windows security or Mixed (Win and SQL) ?
--
HTH,
David Satz
Principal Web Engineer
Hyperion Solutions
{ SQL Server 2000 SP2/6.5 SP5a } { Cold Fusion 5 SP1 } { VSS }
(Please reply to group only - emails answered rarely)
--------------------
"Helen" <hlin@mathsoft.com> wrote in message news:3d517321$1@10.1.10.29...
>
> Open SQL security manager for SQL server 6.5,
> Enter Server name and try to connect with Server,
> enter sa and password, but it give me an error
> " This SQL Server does not support window NT SQL Server Security stored
procedure"
> Any one knows what is the problem, and how to correct it?
> Thanks.
David Satz at 2007-11-11 23:53:33 >
# 2 Re: Security Manager problem in SQL server 6.5
Security mode--Standard.
This is a NT permission issue. I find one article(Q164167) on Microsoft support
website.
Thanks
Helen at 2007-11-11 23:54:34 >
# 3 Re: Security Manager problem in SQL server 6.5
SQL security manager is only for NT security so it would not work w/std.
mode only

"Helen" <hlin@mathsoft.com> wrote in message news:3d5278b4$1@10.1.10.29...
>
> Security mode--Standard.
> This is a NT permission issue. I find one article(Q164167) on Microsoft
support
> website.
> Thanks
>
David Satz at 2007-11-11 23:55:42 >