Hi Sue
It seems i found the cause
I ran setspn but what worked was uppercase L as lowercase L didnt work
When i run the command SETSPN - L ServerName
I got the following:
MSSQLSvc/ServerName .mydomain.co:1433
MSSQLSvc/ServerName .mydomain.co
WSMAN/ServerName .mydomain.co
WSMAN/ServerName
TERMSRV/ServerName .mydomain.co
TERMSRV/ServerName
RestrictedKrbHost/ServerName
HOST/ServerName
RestrictedKrbHost/ServerName .mydomain.co
HOST/ServerName .mydomain.co
I ran it on 2 other database servers and the difference was below:
CmRcService/ServerName
CmRcService/ServerName .mydomain.co
Hence i removed the lines below and replaced them as follows:
C:\>setspn -DMSSQLSvc/ServerName .mydomain.co:1433 ServerName
C:\>setspn -DMSSQLSvc/ServerName .mydomain.co ServerName
Then we added the SPNs using thecommand below
C:\>setspn -ACmRcService/ServerName .mydomain.co ServerName
C:\>setspn -ACmRcService/ServerName ServerName
This worked for me and i am monitoring the server
I think this issue resulted because when installing SQL server i didnt specify the service account per service / feature being installed.
As usually i modify the service account during the installation and with those installations i didnt have this issue
Thanks again for the help Sue
have a lovely week
Kal