SqlSpnManager

Fix SPNs without learning Kerberos.

SqlSpnManager is a PowerShell module for SQL DBAs and sysadmins. It builds the right SPNs from your scenario, runs the forest-wide duplicate check, and registers them — or hands you a clean script for your AD admin when you don't have write rights yourself.

Walk through how it works → Who it's for

The shortest version

If you've spent two hours staring at Cannot generate SSPI context and gone down four different rabbit holes, SqlSpnManager is for you. The everyday call:

Import-Module SqlSpnManager
Start-SqlSpnManager           # interactive wizard, or:

Start-SqlSpnConfiguration `
    -SamAccountName 'svc_sql_prod' `
    -Scenario Standalone -Role Engine `
    -TargetName 'SQLSRV01' -Force

Behind each command: deterministic SPN-string construction, forest-wide duplicate detection before any registration, an AD-write preflight check, per-invocation audit log, and a clean handoff bundle for when you don't own AD yourself. You don't have to know any of that to use it.

Why this exists

Most SQL DBAs hit SPN problems three or four times a career and learn it the hard way each time: from scratch, from a Microsoft doc that's two SQL versions out of date, from an AI that gave three different answers, and from an internal wiki page that turned out to be wrong.

The full origin story is on the Who it's for page.

What's in the box

Status: v1.4.0 ready. Currently distributed via the GitHub repository (PowerShell Gallery publish pending the owner's pre-publish quality bar). MPL-2.0 licensed (open source). Sole-maintainer project: bug reports and feature requests welcome via Issues; pull requests closed by policy. Anyone may fork and continue under MPL-2.0 terms. See Who it's for for the reasoning.