Question: What Is SPN SQL Server?

What is an SPN?

A service principal name (SPN) is a unique identifier of a service instance.

SPNs are used by Kerberos authentication to associate a service instance with a service logon account.

This allows a client application to request that the service authenticate an account even if the client does not have the account name..

How do I find the SQL Server SPN?

Verify SPN has been successfully registered Using SETSPN Command Line Utility. In Command Line enter the following command: setspn -L and press enter. Next, you need to look for registered ServicePrincipalName to ensure that a valid SPN has been created for the SQL Server.

How manually register SPN in SQL Server?

To manually create a domain user Service Principle Name (SPN) for the SQL Server service accountClick Start, click Run and then enter cmd in the Run dialog box.From the command line, navigate to Windows Server support tools installation directory. … Enter a valid command to create the SPN.More items…

How do I set up SPN?

The steps to follow to configure an SPN account for an application server are:Assign the SPN to the Active Directory account using the setspn command.Repeat this command for any number of SPN to the same account.Generate a keytab file for the user account.

How do I find my server SPN?

To view SPNs registered for a security principal, you can use the Setspn command from the Windows 2003 Support Tools, using the -l parameter and the name of the server.

How do I check my SPN list?

Viewing SPNs To view a list of the SPNs that a computer has registered with Active Directory from a command prompt, use the setspn –l hostname command, where hostname is the actual host name of the computer object that you want to query.