Get-SqlSpnDiscoveryEngine Scans local Windows services for SQL Server identities and resolves their TCP ports.
Description
Returns one row per discovered SQL service (engine, agent, named instances) with its run-as identity, the instance name, the resolved TCP port from the registry (not assumed to be 1433), and the current Windows service state.
Useful for ad-hoc operator inspection ("what SQL services are running on this host, and what are they running as?") and as the data source for the interactive Start-SqlSpnManager flow.
Recipes
Recipe 1
EXAMPLE 1
Get-SqlSpnDiscoveryEngine
Recipe 2
EXAMPLE 2
Get-SqlSpnDiscoveryEngine | Where-Object Status -eq 'Running' | Format-Table
Notes
Local discovery only. For remote inspection, run remotely via Invoke-Command or use Get-SqlSpnInfrastructure -ComputerName for a single named target.
Was this page helpful? Report an issue or suggest an improvement →