Get the sa password possible?

Hello,
Is it possible to get or change the existing sa password for microsoft
sql server 2000 as i've forgotten it?
I'm able to use Enterprise Manager by via Windows Authentication, but
i need to connect to a database with SQL Authentication.
Thanks,
jack.Hello,
YOu can not see the password, but you can change the password. All you have
to do is:-
1. Login into the query analyzer using windows authentication
2. Execute the below query to change the SA password
sp_password NULL,'Newpassword','sa'
This will change the password of SA to a new password. THis will work well
if you r windows user is part od Admin group.
Thanks
Hari
"Jack" <bradnerdhss@.hotmail.com> wrote in message
news:1171849045.996306.258230@.s48g2000cws.googlegroups.com...
> Hello,
> Is it possible to get or change the existing sa password for microsoft
> sql server 2000 as i've forgotten it?
> I'm able to use Enterprise Manager by via Windows Authentication, but
> i need to connect to a database with SQL Authentication.
> Thanks,
> jack.
>|||On Feb 19, 11:19 am, "Hari Prasad" <hari_prasa...@.hotmail.com> wrote:
> Hello,
> YOu can not see the password, but you can change the password. All you hav
e
> to do is:-
> 1. Login into the query analyzer using windows authentication
> 2. Execute the below query to change the SA password
> sp_password NULL,'Newpassword','sa'
> This will change the password of SA to a new password. THis will work well
> if you r windows user is part od Admin group.
> Thanks
> Hari
> "Jack" <bradnerd...@.hotmail.com> wrote in message
> news:1171849045.996306.258230@.s48g2000cws.googlegroups.com...
>
>
>
>
> - Show quoted text -
Yes thanks. That worked perfectly.
Jack.