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]

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 suggestionNope. 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...
> > 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
> >
>
>|||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...
> 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...
> > > 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
> > >
> >
> >
> >

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 suggestionNope. Set a string password and make sure that no.one knows that password. O
r 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.g
bl...
> 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 bo
th
> 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 mo
de
> 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]