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

Microsoft Logo

Microsoft

Healthgrades Logo

Healthgrades

Philips Logo

Philips

Illumina Logo

Illumina

Qualco Logo

Qualco

Schlumberger Logo

Schlumberger

Bistech Logo

Bistech

Sage Logo

Sage

Ericson Logo

Ericson

Jack Links Logo

Jack Links

MacDonald Humfrey (Automation) Ltd. Logo

MacDonald Humfrey (Automation) Ltd.

Capita Secure Information Solutions Ltd Logo

Capita Secure Information Solutions Ltd

Epic Games Logo

Epic Games

Slaughter and May Logo

Slaughter and May

Lockheed Martin Logo

Lockheed Martin

NIT A/S

DFDS Logo

DFDS

SuperControl Logo

SuperControl

Washington Department of Transport Logo

Washington Department of Transport

Royal Air Force Logo

Royal Air Force

New Hampshire Supreme Court Logo

New Hampshire Supreme Court

Department of Work and Pensions (UK) Logo

Department of Work and Pensions (UK)

Washington Department of Enterprise Services Logo

Washington Department of Enterprise Services

Ghana Police Service Logo

Ghana Police Service

Kongsberg Maritime Logo

Kongsberg Maritime

Sage Logo

Sage

Microsoft Logo

Microsoft

YearUp.org Logo

YearUp.org

Higher Education Statistics Agency Logo

Higher Education Statistics Agency

Qualco Logo

Qualco