How to Configure the Service Principal Name

Use the SetSPN.exe command-line tool to add a Service Principal Name (SPN) directory property for the Active Directory service account on the data tier domain controller. You use an SPN to locate a target principal name for running a service.

SetSPN.exe is a Microsoft Windows support tool that is located on the Windows Server 2003 or Windows Server 2008 CD. For more information about how to use SetSPN.exe, see http://g o .microsoft.com/fwlink/?LinkId=71820.

For more information about how to use SPN names in Kerberos, see https://go.microsoft.com/fwlink/?LinkId=71821.

To configure the SPN

1. Click Start, click Run, type cmd, and then click OK.

2. At the command prompt, type the following:

   <path> setspn.exe -A MSSQLSvc/StagingSQL.Domain2.corp.com:1433 runtimeuser
   if SQL Cluster
   <path> setspn.exe -A MSSQLSvc/SQLVRTL.Domain2.corp.com:1433 runtimeuser
   

   where <path> is the drive and location of the SetSPN.exe file.

3. To verify that the SPN is set, type the following at the command prompt:

   Setspn -L runtimeuser
   

See Also

Other Resources

What Are the Accounts and Groups to Create?

Configuring a Domain Controller

Building the Data Tier