How to change a lost SA password in SQL Server 2000
1 - download sysinternals from :
http://technet.microsoft.com/en-us/sysinternals/bb897553
2 – Put it in c:\bin
3 – kickoff a cmd window (running as Administrator) that will run PsExec and launch another cmd window running as cmd – the parameters I used for PsExec are: Interactive (-i) and Run as System (-s):
4 – you’ll get a another windows as internal admin now you can run the OSQL command to change the password
5 – Test it :
sp_password @old = null, @new = ‘test123′, @loginame =’sa’