SQLServerPSModule
SQLServerPSModule copied to clipboard
SQL Server PowerShell Provider (SQLSERVER:\SQLRegistration): Group name should not be case-sensitive
The SQL Server PowerShell Provider fails to locate a group of registered servers when the group's name is typed with the wrong capitalization.
Steps to Reproduce the Problem:
- Launch SQL Server Management Studio.
- Go to Registered Servers.
- Add a group to "Local Server Groups" named "FirstWatch".
- Launch PowerShell.
- Run this script:
Import-Module SQLServer
cd "SQLSERVER:\SQLRegistration\Database Engine Server Group\Firstwatch"
Expected Result: The current location should change to the FirstWatch group.
The PowerShell documentation says:
As a general principle, PowerShell is as case insensitive as possible while preserving case and not breaking the underlying OS.
Actual Result:
Set-Location: Cannot find path 'SQLSERVER:\SQLRegistration\Database Engine Server Group\Firstwatch' because it does not exist.
System Information:
- Microsoft Windows Version 22H2 (OS Build 19045.6456)
- SQL Server Management Studio version 20.2.1
- PowerShell version 7.4.13
- SQL Server PowerShell module version 22.4.5.1