Tag Archives: SQL Server

  • Forgot SA Password on SQL Server??

    Here’s the solution I. Force SQL server to support mixed-mode authentication. 1. Run REGEDIT 2. Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQLServer NOTE: This key may vary slightly based on the installed version and instance name. 3. Set “LoginMode” to 2. 4. Restart SQL Server. (Source: http://support.microsoft.com/kb/285097 ) II. Force SQL server to let you in temporarily […]