reset sa pwd in sql server 2005 express

Question

i have forgotten my sa pwd in sql server 2005 express edition on a computer which has Windows Vista Please let me know as how to reset it

Jan Montano · Answer

By default in SQL Server 2005 members of builtin\Administrators have sysadmin privileges on SQL server. You can use a machine administrator account to reset the SA password using ALTER LOGIN. source: MSDN forum