SSMS18.6: microsoft.sqlserver.management.iregistrationservice not found

charin 16 Reputation points
2020-09-10T16:23:05.517+00:00

service 'microsoft.sqlserver.management.iregistrationservice' not found (microsoft.sqlserver.management.sdk.sqlstudio)

I found the error above when I try to connect database engine with SQL Server Authentication. It shows the error but everything seems fine, I think it may cause of trouble later. I try to fix that with many solutions, but it still doesn't work at all. (re-installed SSMS and SQL Server, repaired both)

So, I checked to C:\Program Files\Microsoft SQL Server\150\Tools\Binn and I can't find ManagementStudio folder. I think this will be the cause of this problem but I don't know how to fix that.

Please, give me some advice. Thank you so much.

P.S. I use Microsoft SQL Server 2019 version 15.0.4013.40

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,691 questions

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. m 4,271 Reputation points
    2020-09-11T05:30:56.047+00:00

    Hi @charin ,

    Solution:
    Try to run SSMS as Administrator.

    And SSMS 18.6.exe:
    Default Path: C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe
    23858-ssmsexe.jpg

    BR,
    Mia

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    6 people found this answer helpful.
  2. Weezy Bored 31 Reputation points
    2020-09-17T23:43:11.947+00:00

    This SSMS issue is very common since Microsoft implemented the Ransomware Protection in Windows. It is not an installation issue: you don't need to repair or reinstall SSMS. You don't need to run SSMS "as an administrator," either. SSMS needs to create/access a sub-folder "SQL Server Management Studio" in your profile Documents folder, so it is a permissions issue: something is blocking SSMS.exe from accessing your profile Documents folder. Most likely cause is the new Windows Ransomware Protection of your profile folders. The easiest fix is to disable Ransomware Protection in Windows. The next easier fix is to manually add the required "SQL Server Management Studio" sub-folder to your profile Documents folder ;)

    6 people found this answer helpful.
  3. charin 16 Reputation points
    2020-09-14T07:46:26.003+00:00

    it's work now. I just select custom report... in SSMS. So, it restarts itself automatically. Then, it's work! I'm still so confused. but, if have the same problem again. I will comment on this thread.

    2 people found this answer helpful.
  4. Fredy Nüesch 11 Reputation points
    2020-10-14T08:57:48.5+00:00

    I had the same issue. Just go the the program folder of SSMS C:\Program Files (x86)\Microsoft SQL Server Management Studio 18 and remove the write protection of this folder and all subfolders. ;)

    2 people found this answer helpful.
  5. Guoxiong 8,126 Reputation points
    2020-09-10T20:11:27.863+00:00

    C:\Program Files (x86)\Microsoft SQL Server\150\Tools\Binn\ManagementStudio