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.​

Slaughter and May Logo

Slaughter and May

Cognizant Microsoft Business Group (MBG) Logo

Cognizant Microsoft Business Group (MBG)

Capita Secure Information Solutions Ltd Logo

Capita Secure Information Solutions Ltd

Boeing Logo

Boeing

DFDS Logo

DFDS

Graham & Brown Logo

Graham & Brown

Hubtel Ghana Logo

Hubtel Ghana

ProgramUtvikling Logo

ProgramUtvikling

YearUp.org Logo

YearUp.org

Schlumberger Logo

Schlumberger

ALS Life Sciences Logo

ALS Life Sciences

Workday Logo

Workday

Illumina Logo

Illumina

Alignment Healthcare Logo

Alignment Healthcare

Genus Breeding Ltd Logo

Genus Breeding Ltd

Jack Links Logo

Jack Links

Slicedbread Logo

Slicedbread

Microsoft Logo

Microsoft

Nottingham County Council Logo

Nottingham County Council

Royal Air Force Logo

Royal Air Force

Washington Department of Enterprise Services Logo

Washington Department of Enterprise Services

Washington Department of Transport Logo

Washington Department of Transport

Ghana Police Service Logo

Ghana Police Service

Department of Work and Pensions (UK) Logo

Department of Work and Pensions (UK)

Higher Education Statistics Agency Logo

Higher Education Statistics Agency

Capita Secure Information Solutions Ltd Logo

Capita Secure Information Solutions Ltd

Teleplan Logo

Teleplan

Jack Links Logo

Jack Links

Microsoft Logo

Microsoft

Flowmaster (a Mentor Graphics Company) Logo

Flowmaster (a Mentor Graphics Company)