Shaun Cassells at MyITForum.com

How to check if Service Principle Name (SPN) is enabled?

While troubleshooting recently, I came across an instance where I needed to verify a SPN was still set correctly for a remote SQL instance.

1. Go to your SQL box
2. Navigate to:
1. X64 - :\Program Files (x86)\Support Tools
2. X32 - :\Program FIles\Support Tools
3. Run Setspn.exe -L <ComputerName>

or

1. Install ADSIEdit.msc
2. Locate the server you wish to verify
3. Right Click Propteries
4. Scroll down to servicePrincipalName

Results are returned.