lock sa account

How do I go about locking the sa account?
Thx!!Hi,
There is no locking concept for SQL Server Logins. Only for OS based users
only locking schemes can be implimented.
So you cant implement a locking mechnaism for SA user. only way is you can
change the password for SA.
--
Thanks
Hari
MCDBA
"angelina" <anonymous@.discussions.microsoft.com> wrote in message
news:1ed8801c45760$ad030630$a301280a@.phx.gbl...
> How do I go about locking the sa account?
> Thx!!|||You cant lock the account.
The best you can do is the use a well encrypted password.
"angelina" <anonymous@.discussions.microsoft.com> wrote in message
news:1ed8801c45760$ad030630$a301280a@.phx.gbl...
> How do I go about locking the sa account?
>
> Thx!!|||There is one alternative.....
You can create a new account, make it a sysadmin.
Then remove SA from the sysadmin roles.
You still have SA available (you have to) but it will no longer have admin
rights.
MAKE SURE YOU KEEP A COPY OF THE PASSWORDS otherwise it could become a
complete disaster!.
Immy
"angelina" <anonymous@.discussions.microsoft.com> wrote in message
news:1ed8801c45760$ad030630$a301280a@.phx.gbl...
> How do I go about locking the sa account?
>
> Thx!!|||In addition to giving it a strong password, the other option
is to set the server to use Windows Authentication only. If
SQL Server is running under Windows Authentication only, the
sa login can't be used to log into SQL Server - only Windows
logins would be accepted.
-Sue
On Mon, 21 Jun 2004 00:23:40 -0700, "angelina"
<anonymous@.discussions.microsoft.com> wrote:
>How do I go about locking the sa account?
>Thx!!sql