Registering SQLServers in SSMS v20 using Powershell
Hello
I have a new VM – Windows 11,
Installed SSMS V20.1 today
Installed SQLServer Powershell Module. SQLServer Module version is 22.2.0 . Only 1 version installed.
(Install-Module -Name SqlServer -Repository PSGallery -Force)
When I go into powershell and do the following
Set-Location “SQLSERVER:SQLRegistrationdatabase Engine Server Group”
new-item “TestFolder”
This TestFolder does not show up in SSMv2 (Registered Servers Group)
Similarly If i got into SSMS v20, and create a folder named “TestSSMS”,
This does not show up in the powershell sqlserver directory
I need to run a powershell command that populates the registered servers list. there are at least 30 servers that i need to register – hence powershell is a better option to do the registration.
Any help would be grateful to fix this?
HelloI have a new VM – Windows 11,Installed SSMS V20.1 todayInstalled SQLServer Powershell Module. SQLServer Module version is 22.2.0 . Only 1 version installed.(Install-Module -Name SqlServer -Repository PSGallery -Force)When I go into powershell and do the followingSet-Location “SQLSERVER:SQLRegistrationdatabase Engine Server Group”new-item “TestFolder” This TestFolder does not show up in SSMv2 (Registered Servers Group)Similarly If i got into SSMS v20, and create a folder named “TestSSMS”, This does not show up in the powershell sqlserver directoryI need to run a powershell command that populates the registered servers list. there are at least 30 servers that i need to register – hence powershell is a better option to do the registration. Any help would be grateful to fix this? Read More