Link to home
Start Free TrialLog in
Avatar of jpletcher1
jpletcher1Flag for United States of America

asked on

Duplicate SPNs for SQL instances

We renamed some SQL servers and  manually had to create new SPNs for them.  We use a different service account for the SQL Agent and the actual SQL Service itself.  When you create a SPN for SQL, do you associate the host and the SQL Agent account or the SQL Service account?
ASKER CERTIFIED SOLUTION
Avatar of TempDBA
TempDBA
Flag of India image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jpletcher1
jpletcher1
Flag of United States of America image

ASKER

Thanks.  I for some reason thought it was the agent account.  One one of our new servers only the sql agent account is setup as the spn and it seems to work fine.  The agent account and the service account are different.  I'm a little confused how it is working.  That one is more of a reporting server though, but I assume the same rules apply to it and it should be registered with the service account for spn and not the agent account?