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
