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
No related videos found.
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.
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
Jack Links
Flowmaster (a Mentor Graphics Company)
Schlumberger
Big Data for Humans
Lockheed Martin
Microsoft
Deliotte
ALS Life Sciences
Higher Education Statistics Agency
Trayport
Graham & Brown
Milliman
Workday
Alignment Healthcare
Ericson
Slicedbread
Epic Games
Ghana Police Service
Royal Air Force
Department of Work and Pensions (UK)
Washington Department of Transport
New Hampshire Supreme Court
Nottingham County Council
Emerson Process Management
Slicedbread
Graham & Brown
Qualco
Alignment Healthcare
Jack Links