My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/How to access SQL Server when you've forget the password
The new RSS feed is here
There is a little known feature of SQL Server 2005 is
that when you start SQL Server in single user mode local administrators of the
server have sysadmin access to the sql server.
You may feel this a security concern, but if a user can get local admin
of your server, and restart your service then having sysadmin access to your SQL
Server is the least of your problems.
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/How to access SQL Server when you've forget the password