SQLServerPSModule icon indicating copy to clipboard operation
SQLServerPSModule copied to clipboard

SQL Server PowerShell Provider (SQLSERVER:\SQLRegistration): Group name should not be case-sensitive

Open ZianAtFirstWatch opened this issue 2 months ago • 0 comments

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:

  1. Launch SQL Server Management Studio.
  2. Go to Registered Servers.
  3. Add a group to "Local Server Groups" named "FirstWatch".
  4. Launch PowerShell.
  5. 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

ZianAtFirstWatch avatar Oct 31 '25 21:10 ZianAtFirstWatch