Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

SQL Server Management Studio error

Posted on 2011-03-20
Last Modified: 2012-05-11
When starting Microsoft SQL Server Management Studio (for SQL Server 2008), I get the error cannot create a stable subkey under a volatile parent key.
How do I fix this?
Question by:murbro
  • 3
  • 3

Expert Comment

ID: 35176408
Delete the registration key at HKEY_CURRENT_USER/Software/Microsoft/Microsoft SQL Server or HKCU\Microsoft\Microsoft SQL Server. Before you delete the make sure that you create a back up of that by right-clicking it and selecting export and saving to a file, just to be on the safe side in case deleting that key creates any other problem. Next time you start Microsoft SQL Server Management Studio it should automatically configure as if it's starting for the first time.

Also seems like they also solved by uninstalling SQL Online Books along with Management Studio, and just reintalled the Studio without the books.  

Others with the same problem I am referencing here -

I hope that helps!


Author Comment

ID: 35176454
Thanks where do I find  HKEY_CURRENT_USER/Software/Microsoft/Microsoft SQL Server ?

Expert Comment

ID: 35177907
Goto run, regedit, navigate from there to HKEY_CURRENT_USER/Software/Microsoft/Microsoft SQL Server
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.


Author Comment

ID: 35179073
The system wouldn't allow the deletion of that file ;(

Accepted Solution

ITSuperman earned 500 total points
ID: 35180478
You must not have admin privileges on that PC then..You will have to get with your IT dept if you are in a corporate environment and have one of them do it possibly.  If not, and this is your PC, then you need to login as admin on the box.

Author Closing Comment

ID: 35187303

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

792 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question