Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 sa login

Author  Topic 

fmardani
Constraint Violating Yak Guru

433 Posts

Posted - 2004-11-09 : 09:59:24
How can I change the sa password in sql2k?
Thanks

fmardani
Constraint Violating Yak Guru

433 Posts

Posted - 2004-11-09 : 10:07:19
Found the way to do this. Thanks
Go to Top of Page

CanadaDBA

583 Posts

Posted - 2004-11-09 : 13:22:37
It's not bad idea to post the solution for others as well. It can save others time.
quote:
Originally posted by fmardani

Found the way to do this. Thanks



Canada DBA
Go to Top of Page

fmardani
Constraint Violating Yak Guru

433 Posts

Posted - 2004-11-09 : 16:42:16
security, logins, look for sa account, right click, properties, set the password as necessary.
Go to Top of Page

elwoos
Master Smack Fu Yak Hacker

2052 Posts

Posted - 2004-11-09 : 17:29:36
While on the subject it's highly recommended (see numerous other posts) that this password is secure e.g. '@3#£456ddr~&)_={!A]sdfr' and that it is not used as a login account except under extreme circumstances.

Ours are around 13 characters and are kept in a safe



steve


To alcohol ! The cause of - and solution to - all of life's problems
Go to Top of Page
   

- Advertisement -