Configuring Kerberos with SQL Server

I’m putting this here, as I keep needing it!

To have SQL Server use Kerberos configuration, you need to set up two SPNs for the SQL Server Account:

setspn.exe MSSQLSvc/{NETBIOS NAME OF SQL SERVER}:{PORT NO} {SQL SERVER SERVICE ACCOUNT}
setspn.exe MSSQLSvc/{FQDN NAME OF SQL SERVER}:{PORT NO} {SQL SERVER SERVICE ACCOUNT}

Make sure that the SQL Server Service account is delegated for Kerberos in AD and so is the SQL Server itself.

Then in SSMS run the following:

SELECT auth_scheme FROM sys.dm_exec_connections WHERE session_id=@@spid

Should say ‘KERBEROS’.

Cheers

Dave Mc

Advertisements

About davemcmahon81
Software Developer & Architect, User Group Leader, Speaker, Writer, Blogger, Occasional Guitarist, Man-made Global Warming Sceptic, Climate Change Believer, General Optimist but most of all proud Husband and Dad ...

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: