Registering ServicePrincipalNames for SQL

This will set the SQL service to run under a Domain account and create a ServicePrincipleName in Active Directory

Replace the following with you own Server name, and Service Account

setspn -A MSSQLSvc/MEMCM-MP:1433 DEVLAB\sv.MEMCM_SQL

Lets also add the FQDN just to be on the safe side

setspn -A MSSQLSvc/MEMCM-MP.Devlab.local:1433 DEVLAB\sv.MEMCM_SQL