Setting the Service Principal Name using CData ADO.NET Provider for SharePoint
Connection string
This CData ADO.NET Provider for SharePoint connection string can be used for connections to SharePoint.
URL=http://sharepointServerName/;User=myUsername;Password=myPassword;
Kerberos SPN=myServicePrincipalName;
Use this when the Service Principal Name on the Kerberos Domain Controller is not the same as the URL that you are authenticating to.