Lock Outs in SQL Server

Title: Lock Outs in SQL Server
Category: Literature / English
Details: Words: 568 | Pages: 2.4 (approximately 235 words/page)

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 MicrosoftSQLServerMSSQLServerLoginMode …showed first 75 words of 568 total…

You are viewing only a small portion of the paper. Please login or register to access the full copy.

…showed last 75 words of 568 total…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.

Need a custom written paper?