Weekly Dynamic: Resetting the ‘sa’ password

What do you do when no one has the ‘sa’ password for SQL and none of the typical network users will let you reset the ‘sa’ password? I ran into this recently with a new client. Their previous VAR had managed SQL for them and had never given them the ‘sa’ password. On top of that they had locked out other network users and refused to give the new CTO the ‘sa’ password. If you have access to the SQL Server and if you have a login that is a local administrator on the SQL box, you can work around this. I used the instructions from Tim Radney at http://timradney.com/2013/11/21/how-to-reset-the-sa-password-in-sql-server/ to successfully change the ‘sa’ password and recover access to the SQL Server. It worked out well for us and for them since the SQL Server hadn’t been backed up since 2012. I didn’t leave until we had a good backup and recurring backup set in a maintenance plan.

One Reply to “Weekly Dynamic: Resetting the ‘sa’ password”

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.