See my comment above. I used Process Monitor to trace the registry access and found it was getting an Access Denied while trying to write:
3:16:40.8405491 PM sqlservr.exe 8756 RegCreateKey HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11E.LOCALDB\MSSQLServer ACCESS DENIED Desired Access: Write
I got around this by opening the Registry Editor and giving Everyone full access to HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11E.LOCALDB\MSSQLServer
. Then I changed the default location and removed the Everyone access once it was done. This made the following extra keys that weren't there before:
DefaultData
DefaultLog
BackupDirectory
My guess is since you have remamants of failed installation still present in your system that is why you cannot install the new instance. This can be fixed by deleting few registry keys related to SQL server. Follow below method , this method was given by Microsoft forum team and is recommended way to remove have helped me and forum users many time . If you have multiple instances below suggesstion would not work so dont use it.
First please refer to below Microsoft support link for what actions to follow before removing SQL Server instance. Its is for 2008 r2 but would be applicable to 2012 as well.
http://support.microsoft.com/kb/955499/en-gb
If still you face problem you might as well try below suggesstion which involves removing registry entries.
Note: Removing necessary registry entries might cause inconsistency so backup registry before doing changes.
•1. Uninstall the existing SQL Server and all the components from the add remove program.
•2. Backup the registry . Please read in details the MS link before proceeding.
•3. Delete the following keys using regedit:
◦--HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
◦--HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
•4. Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall and delete all the sub-keys referencing SQL Server.
•5. Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and delete all the keys referencing SQL Server.
•6. Rename all the SQL Server folders in the computer.
•7. Reboot the machine.
If you dont find this useful or have confusion dont proceed. Open a case with Microsoft and allow them to have a look at your system. with my experience with many failed installation registry keys are left in corrupted state and only solution would be to remove them.But you need expert to fiddle with registry
PS: Above method was suggested in SQL server forum and works well.
Of course if you can please revert it would be helpful
Best Answer
That dialog asks you for the installation media, pay attention. You need to specify the location from where you've run the original install. That is not an Express uninstall, you are uninstalling a licensed SSMS, so you should provide your original, licensed, CDs.