SQLServerPSModule icon indicating copy to clipboard operation
SQLServerPSModule copied to clipboard

SQLRegistration does not work with SSMS 20.0 and SqlServer module 22.2.0

Open PeterPorsche opened this issue 1 year ago • 1 comments

I can add a new item to the "PS SQLSERVER:\SQLRegistration\Database Engine Server Group" but the new item does not show up in SSMS 20.0 "Registerd Servers"

example: New-Item -Name $(encode-sqlname 'test_reg_server') -ItemType Registration -Value ("Server=TestServer; Database=test_database; Integrated Security=true");

PeterPorsche avatar Mar 29 '24 09:03 PeterPorsche

Ran into this issue as well. I think the issue is that the dll: Microsoft.SqlServer.Management.RegisteredServers.dll which I think has references specific for ssms 19.

jeffalope avatar May 08 '24 21:05 jeffalope

Interesting. This could be tricky to fix/address because I cannot think of away (at least today) to differenciate between 19 and 20. I'll check with the SMO owner and see what we can do about it.

Or maybe I can look at trying to update both (from the PS Provider): whichever is there, I update it. Uhm... I need to take a closer look at the code and see...

Matteo-T avatar May 27 '24 09:05 Matteo-T

I've bumped the upcoming version v22.3 to the latest SMO, so once it's released it should switch to the new SSMS 20 stuff. I cannot think of a simple way to support both at the same time and, hopefully, the bump 19->20 was a fairly isolated case.

Matteo-T avatar Jun 30 '24 11:06 Matteo-T

Can you try v22.3.0 and confirm that the SSMS20 servers are OK now? I can't have both 19 and 20...

Matteo-T avatar Jul 04 '24 21:07 Matteo-T

Thank you. I confirm that SqlServer module V22.3.0 is working with SSMS20.1, but as you mentioned not with SSMS19.3.

PeterPorsche avatar Jul 05 '24 14:07 PeterPorsche