SQL Server Management Studio 2016启动、修复及打开数据库文件夹报错求助

Hey there, I know how frustrating it is when SSMS 2016 won’t start, even after multiple reinstalls—and that 0x800713ec error popping up during repairs and when accessing database folders makes it even worse. Let’s walk through targeted fixes that have resolved this issue for many users:

• 彻底清理 SSMS 残留文件与注册表项
  Half the time, reinstalls fail because leftover files/registry entries are messing things up. Here’s how to wipe them clean:

  1. Uninstall SSMS 2016 and any related SQL Server components via Programs and Features in Control Panel. For stubborn uninstalls, use Microsoft’s Program Install and Uninstall Troubleshooter to force removal.
  2. Delete these residual folders (replace <YourUsername> with your actual Windows username):
     • C:\Program Files (x86)\Microsoft SQL Server Management Studio 13
     • C:\Users\<YourUsername>\AppData\Roaming\Microsoft\SQL Server Management Studio\13.0
     • C:\Users\<YourUsername>\AppData\Local\Microsoft\SQL Server Management Studio\13.0
  3. Backup your registry first, then open regedit and delete these keys if they exist:
     • HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server Management Studio\13.0
     • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server Management Studio\13.0

• Verify .NET Framework & Windows Updates
  SSMS 2016 relies heavily on .NET Framework 4.6+. Make sure you have this version installed, and that all .NET and Windows updates are applied:

  1. Check your .NET version via regedit (look at HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\NET Framework Setup\NDP\v4\Full; the Release value should be at least 394254 for 4.6.2).
  2. Run Windows Update and install all pending security/feature updates—missing system components often trigger these installation errors.

• Reset Windows Installer Service
  A glitchy Windows Installer can cause repair failures. Fix it with these steps:

  1. Open Command Prompt as Administrator.
  2. Run these commands one after another:

     msiexec /unregister
     msiexec /regserver
     

  3. Restart your PC, then try repairing or reinstalling SSMS again.

• Fix Database Folder Permissions
  The error when accessing database folders points to a permission issue. Let’s resolve that:

  1. Locate your SQL Server data folder (usually C:\Program Files\Microsoft SQL Server\MSSQL13.<YourInstanceName>\MSSQL\DATA).
  2. Right-click the folder → Properties → Security → Edit.
  3. Add your Windows user account and grant it Full Control permissions (you can tighten this later if needed).
  4. Check the Owner tab to ensure your user account owns the folder—if not, take ownership via the advanced settings.

• Temporarily Disable Third-Party Security Software
  Antivirus or firewall tools sometimes block SSMS installation/repair processes. Disable them temporarily, then attempt the repair or reinstall. Remember to re-enable them once done.

• Use the Offline SSMS Installer
  If you used the online installer before, corrupted downloaded files might be the culprit. Grab the SSMS 2016 offline installation package, run it locally, and avoid network-related file issues.

Give these steps a try in order—start with the cleanup, since that’s the most common fix for persistent reinstall issues. Let me know if any of these resolve your problem!

内容的提问来源于stack exchange，提问作者Juan