[AccessD] MSDE Password for sysadmin SA; forgotten or lost Change Method

MartyConnelly martyconnelly at shaw.ca
Tue Jan 28 19:19:00 CST 2003


Given the talk about worms don't forget to change your MSDE SysAdmin 
 account password
Otherwise if you connect SQL to the Net everyone and  his dog will be in 
there. Nevermind the dog with worms.

Intially it is "sa" password = Null


I forgot/lost the sa password. What to do?

Forgot or lost your sa password? Never changed.  Don't worry, there is a 
way out :)

Login to the SQL Server computer as the Administrator of that computer. 
Open Query Analyzer and connect to SQL Server using Windows NT 
authentication. Run sp_password as show below to reset the sa password:
To login
go to windows run command
type in Osql -E
This logs in through Windows security , if  startup window just flashes 
restart SQL Server
from tray icon.
enter next two lines to change password to willneverforget

EXEC sp_password @new = 'will_never_forget_again', @loginame = 'sa'
GO






More information about the AccessD mailing list