SQL Server Management Studio: IRegistrationService not found

Question

My company recently restricted access to the Documents folder during a recent OneDrive migration and SSMS will no longer run. I get the following error stated below. My understanding is that SSMS needs to create/access a sub-folder "SQL Server Management Studio" in your profile Documents folder, so it is a permissions issue. How do I get around this if my Documents folders is locked down by an administrator?

TITLE: Microsoft SQL Server Management Studio

------------------------------

Service 'Microsoft.SqlServer.Management.IRegistrationService' not found (Microsoft.SqlServer.Management.SDK.SqlStudio)

------------------------------

BUTTONS:

OK

------------------------------

Answer 1

What? How will most any apps work if you don't have write access to the one location in all of Windows that every user should have write access to? Your Documents folder is the only place you would normally have write access to. Pretty much every app writes to that location including Office so if you cannot write to it then apps won't work.

In cases where companies "lock down" Documents then they actually just point your documents directory to someplace else they want you to write to. You should probably follow up with your network administrators. I don't think they removed your ability to write to your personal documents folder.

SSMS does allow you to change where it stores some files but the particular item you mention I believe is not configurable. It will attempt to store its data in your user's Documents directory (whereever that may be).

Answer 2

Hi @Kelly, Jason [ETHUS] ,
I don't know the version of your SQL, so I guess that this article might be helpful.
https://spgeeks.devoworx.com/service-microsoft-sqlserver-management-iregistrationservice-not-found/
If it still doesn't work pls let me know and tell me your vesion of SQL, and let's find other ways to fix the error.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment"

Answer 3

Hi @Kelly, Jason [ETHUS] ,
How about the problem? :)