Issue: SQL
server 2012 - The application cannot start
Last Thursday I installed SQL Server 2012 client tools on the Windows 8 Dev and everything
was working fine. Then after few days, I installed the Visual Studio 11
Developer Preview.
The next morning after I booted up, I have not been able to
launch SQL Server 2012.
Solution:
This happens after
installing SQL Server 2012 (Code named "Denali CTP3") or later,
running SSMS successfully, then (later) install VS11 Dev Preview, and then run
SSMS.
Dev11 Preview improperly recognize SQL Server Denali SSMS as a version 11 application and it updates the current user’s setting in SSMS registry key during the setup. This issue occurs only when Dev11 Preview is installed after the installation of SSMS.
SQL Server 2012 SSMS has a built-in security and resiliency feature for any corrupted configuration in HKCU registry key. The corrupted registry keys can be simply deleted then SSMS automatically reconstructs it with correct values during the next startup procedure.
• Start regedit.exe
• Go to HKEY_CURRENT_USER\Software\Microsoft\SQL Server Management Studio
• Delete 11.0_Config
• Restart ssms.exe
Dev11 Preview improperly recognize SQL Server Denali SSMS as a version 11 application and it updates the current user’s setting in SSMS registry key during the setup. This issue occurs only when Dev11 Preview is installed after the installation of SSMS.
SQL Server 2012 SSMS has a built-in security and resiliency feature for any corrupted configuration in HKCU registry key. The corrupted registry keys can be simply deleted then SSMS automatically reconstructs it with correct values during the next startup procedure.
• Start regedit.exe
• Go to HKEY_CURRENT_USER\Software\Microsoft\SQL Server Management Studio
• Delete 11.0_Config
• Restart ssms.exe
