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