a·gen·tic a·gil·i·ty

Connecting to SQL Server using DNS update

Explains how updating DNS and Service Principal Names (SPNs) in Active Directory enables secure Windows Authentication connections to SQL Server instances.

Published on
1 minute read
Image
https://nkdagility.com/resources/P0XjI6SRWz-
Subscribe

OK, I now have the additional SPN’s added to AD that I mentioned in my post and a listing returns:

C:>setspn [servername]
Registered ServicePrincipalNames for CN=[servername],OU=Member Servers,DC=[domain],DC=biz:
    MSSQLSvc/spdata.ep-dev.[domain].biz:1422
    MSSQLSvc/spdata.ep-dev.[domain].biz:1433
    MSSQLSvc/[servername].[domain].biz:1422
    MSSQLSvc/[servername].[domain].biz:1433
    SMTPSVC/[servername]
    SMTPSVC/[servername].[domain].biz
    HOST/[servername].[domain]onet.biz
    HOST/[servername]

So when I now try to log into SQL server using spdata.ep-dev.[domain].biz/EPDev and Windows Authentication, all is well and I can connect to the server.

When I try moving the databases I will need to move this SPN to the new SQL Cluster, and it should work there as well.

Here’s hoping…

Technorati Tags: SP 2007

Subscribe

Related Blog

No related videos found.

Connect with Martin Hinshelwood

If you've made it this far, it's worth connecting with our principal consultant and coach, Martin Hinshelwood, for a 30-minute 'ask me anything' call.

Our Happy Clients​

We partner with businesses across diverse industries, including finance, insurance, healthcare, pharmaceuticals, technology, engineering, transportation, hospitality, entertainment, legal, government, and military sectors.​

Emerson Process Management Logo

Emerson Process Management

Jack Links Logo

Jack Links

Flowmaster (a Mentor Graphics Company) Logo

Flowmaster (a Mentor Graphics Company)

Schlumberger Logo

Schlumberger

Big Data for Humans Logo

Big Data for Humans

Lockheed Martin Logo

Lockheed Martin

Microsoft Logo

Microsoft

Deliotte Logo

Deliotte

ALS Life Sciences Logo

ALS Life Sciences

Higher Education Statistics Agency Logo

Higher Education Statistics Agency

Trayport Logo

Trayport

Graham & Brown Logo

Graham & Brown

Milliman Logo

Milliman

Workday Logo

Workday

Alignment Healthcare Logo

Alignment Healthcare

Ericson Logo

Ericson

Slicedbread Logo

Slicedbread

Epic Games Logo

Epic Games

Ghana Police Service Logo

Ghana Police Service

Royal Air Force Logo

Royal Air Force

Department of Work and Pensions (UK) Logo

Department of Work and Pensions (UK)

Washington Department of Transport Logo

Washington Department of Transport

New Hampshire Supreme Court Logo

New Hampshire Supreme Court

Nottingham County Council Logo

Nottingham County Council

Emerson Process Management Logo

Emerson Process Management

Slicedbread Logo

Slicedbread

Graham & Brown Logo

Graham & Brown

Qualco Logo

Qualco

Alignment Healthcare Logo

Alignment Healthcare

Jack Links Logo

Jack Links