SQL SPN Powershell Commands

List User Account Spn:

 Get-ADUSer -Filter { ServicePrincipalName -ne "$null"} -Properties ServicePrincipalName | select 

SamAccountName, ServicePrincipalName

 

List Computer Account Spn
Get-ADComputer -Filter { ServicePrincipalName -ne "$null"} -Properties ServicePrincipalName | select SamAccountName, ServicePrincipalName | Out-String -Width 4096 

Setting SPN:

setSPN -A MSSQLsvc/sqlserver1.contoso.com:59302 contoso\serviceaccount

setSPN -A MSSQLsvc/sqlserver1:59302 contoso\serviceaccount

 

SQL spn and linked server double hop and kerberos

Good link to setup linked server and spn's

https://sqljana.wordpress.com/2017/06/16/sql-server-curse-of-linked-server-security-and-the-fix-pass-through-authentication/


https://www.alexandreviot.net/2014/09/30/sql-server-could-not-register-the-service-principal-name-spn/


Query to see if Kerberos is being used.