[AccessD] Message not deliverable

Administrator administrator at it.glasgow.gov.uk
Wed Jan 29 03:15:19 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



_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd



More information about the AccessD mailing list