Share This Post

How to Query SPN Records

By Garth Jones

While trying to understand Kerberos Double Hop authentication, I needed to check the Service Principal Name (SPN) records for one of my servers. Checking these records meant that I would have to verify each service account and this particular server had 6 different instances of SQL.

Anyways, I stumbled across this tip about how to query AD for all SPN records, so I thought that I would share it with you.

From a CMD prompt, simply run the following command line.

setspn -Q */*Win2k8r2* >>C:spn_recordswin2k8r2.txt

SPN Records

After finding the SPN records, I still wasn’t able to fix the double hop issue I was looking into. I think I’m getting closer to resolving this problem because I don’t see the SQL instance I’m working on listed above. Time to dig deeper!

Share This Post

Enhansoft specializes in providing software solutions, custom reports, and consulting services for retrieving your IT asset inventory. This is done within the system management area focusing on Microsoft System Center Configuration Manager (SCCM) by extending its asset information and reporting capabilities. Enhansoft is a Bronze sponsor of myITforum.com.

Leave a Reply