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.
Slaughter and May
Cognizant Microsoft Business Group (MBG)
Capita Secure Information Solutions Ltd
Boeing
DFDS
Graham & Brown
Hubtel Ghana
ProgramUtvikling
YearUp.org
Schlumberger
ALS Life Sciences
Workday
Illumina
Alignment Healthcare
Genus Breeding Ltd
Jack Links
Slicedbread
Microsoft
Nottingham County Council
Royal Air Force
Washington Department of Enterprise Services
Washington Department of Transport
Ghana Police Service
Department of Work and Pensions (UK)
Higher Education Statistics Agency
Capita Secure Information Solutions Ltd
Teleplan
Jack Links
Microsoft
Flowmaster (a Mentor Graphics Company)