Access deny SA Account

For security reason, does it possible to deny the account sa to access the
SQL Server 2000. I have tried using sp_denylogin or sp_revokelogin but both
failure.
Thanks in advance for any suggestion
Nope. Set a string password and make sure that no.one knows that password. Or run SQL Server in
Windows Only mode.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Thomas Tsang" <thomast@.hkc.net> wrote in message news:%23HFvs7MwEHA.3872@.TK2MSFTNGP11.phx.gbl...
> For security reason, does it possible to deny the account sa to access the
> SQL Server 2000. I have tried using sp_denylogin or sp_revokelogin but both
> failure.
> Thanks in advance for any suggestion
>
|||Even if you run SQL Server in Windows Authentication Only mode, you still
want to set a highly complex password for the sa account. The security mode
setting is only a Windows Registry key setting and is easily switched to
Mixed Authentication mode.
Sincerely,
Anthony Thomas
"Tibor Karaszi" wrote:

> Nope. Set a string password and make sure that no.one knows that password. Or run SQL Server in
> Windows Only mode.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Thomas Tsang" <thomast@.hkc.net> wrote in message news:%23HFvs7MwEHA.3872@.TK2MSFTNGP11.phx.gbl...
>
>
|||I absolutely agree (this is one thing I always push in classes). Thanks for bringing that up. :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"AnthonyThomas" <AnthonyThomas@.discussions.microsoft.com> wrote in message
news:FA9CF586-CC7C-4D84-B95A-46838D49B32A@.microsoft.com...[vbcol=seagreen]
> Even if you run SQL Server in Windows Authentication Only mode, you still
> want to set a highly complex password for the sa account. The security mode
> setting is only a Windows Registry key setting and is easily switched to
> Mixed Authentication mode.
> Sincerely,
>
> Anthony Thomas
>
> "Tibor Karaszi" wrote:
news:%23HFvs7MwEHA.3872@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]