regaining access to sql server having lost sa password
YOU HAVE LOST ACCESS TO SQL SERVER: HOW TO FIX-IT You are working as a trusted DBA responsible for some extremely important SQL Servers for your company. For the sake of security, you have performed the following steps to secure SQL Servers: You have removed any and all built-in administrators account from SQL Server logins You have removed all the users (except SA) that were part of SYSADMIN server role (Including any Windows Accounts and/or SQL Server logins) You have set the password of SA to something extremely complex which is hard to remember For day-to-day operations on SQL Server, you use your domain user account which has DBO permissions on couple of databases but doesn’t have SYSADMIN privileges. Since you set the SA password to be complex and you have not been using it, you forgot the SA password. You are the only person in the company who would know the SA password and now you have lost the SA password. What would you do now? Some quick options I can t...