Lock Outs in SQL Server

Lock Outs in SQL Server If you lock yourself out of SQL Server without being able to log on with a sysadmin login, you don't have to reinstall SQL Server. To access SQL Server, you need to use the registry key for SQL Server 2000 and SQL Server 7.0 that determines the authentication mode of SQL Server. § In SQL Server 7.0, the key is: HKEY_LOCAL_MACHINESOFTWAREMicrosoft MSSQLServerMSSQLServerLoginMode § In SQL Server 2000, the key is: HKEY_LOCAL_MACHINESOFTWAREMicrosoft MicrosoftSQLServer<…

…SQL Server to reflect the changed authentication mode. Note: If you implement these security steps in the wrong order-by deleting the BUILTINAdministrators login, changing your SQL Server authentication mode to Windows Authentication only, then restarting SQL Server, you will have disabled the sa account and you will have no other Windows Authenticated login defined in your SQL Server. Thus, you are locked out. To avoid this situation, implement the security measures in the correct order.