The login for our sql server is the default sa with a password.
I would like to remove the password but cant find where I can actually do
this.
Can someone help ?
TIASetting a blank SA password is not a good idea, it can leave your machine
open to virus attacks. You'd be better off setting the SA password to
something nobody knows and create a new account for people to use with only
the permissions they require.
A. Change the password of a login without a former password
This example changes the password for the login Victoria from a NULL
password to "B3r12-36".
EXEC sp_password NULL, 'B3r12-36', 'Victoria'
--
HTH
Ryan Waight, MCDBA, MCSE
"Poppy" <paul.diamond@.NOSPAMthemedialounge.com> wrote in message
news:OQjbrDEqDHA.2964@.tk2msftngp13.phx.gbl...
> The login for our sql server is the default sa with a password.
> I would like to remove the password but cant find where I can actually do
> this.
> Can someone help ?
> TIA
>|||Poppy wrote:
> The login for our sql server is the default sa with a password.
> I would like to remove the password but cant find where I can
> actually do this.
> Can someone help ?
> TIA
you really dont want to do this. the sa login is the 'system
administrator' to sql and having no password on it will open a massive
hole in your security. You should ideally only use the sa on the server
itself (to prevent sniffer attacks). You should create a seperate login
for day to day activities.
--
Br,
Mark Broadbent
mcdba , mcse+i
=============|||Hi,
You can login to Sql Query analyzer using NT
Administrator ( Provider this has permission to access
sql) and you can reset/change the password using
sp_password - stored procedure.
Pls try this out . Hope this will do the needful.
Raghu
>--Original Message--
>The login for our sql server is the default sa with a
password.
>I would like to remove the password but cant find where I
can actually do
>this.
>Can someone help ?
>TIA
>
>.
>|||>--Original Message--
>Poppy wrote:
>> The login for our sql server is the default sa with a
password.
>> I would like to remove the password but cant find where
I can
>> actually do this.
>> Can someone help ?
>> TIA
>you really dont want to do this. the sa login is
the 'system
>administrator' to sql and having no password on it will
open a massive
>hole in your security. You should ideally only use the sa
on the server
>itself (to prevent sniffer attacks). You should create a
seperate login
>for day to day activities.
>--
>Br,
>Mark Broadbent
>mcdba , mcse+i
>=============>.
>Yes .. you are right ! and If Mr.Poppy had forgotten the
sa password , then change with above step and set the
right password for security reasons.
Raghu
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment