Adding yourself to a SQL instance when you have no clue what the SA password is

Excellent article on how to add yourself to SQL roles if you don’t have access to SQL.  Note that this REQUIRES that your account is a member of the Local Administrators Group and your SQL Services will need to be restarted with an additional startup switch.  This WILL result in a 10-15 minute SQL outage.

http://sigkillit.com/2013/01/02/recover-sa-password-on-microsoft-sql-server/

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: