January 15, 2013 at 5:50 am
I got following error in command prompt
command
---------
1. setspn -A MSSQLSvc/myhost.redmond.microsoft.com:1433 domain account name
Note: The same domain account name running in both MSSQLSERVER, AGENT services, after installation SQL Service account changed.
C:\Users\ananda>setspn -A MSSQLSvc/myhost.redmond.microsoft.com:1433 domain account name
Registering ServicePrincipalNames for CN=domain account name
,OU=SERVICEACCT,DC=in,DC=rl,DC=com
MSSQLSvc/myhost.redmond.microsoft.com:1433
Failed to assign SPN on account 'CN=domain account name
,OU=SERVICEACCT,DC=in,DC=rl,DC=com', error 0x2098/8344 -> Insufficient access rights to perform the operation.
January 15, 2013 at 6:11 am
Your account needs the correct rights in AD to be able to create SPN's, you could always ask your domain admins to assign the permissions to the service account so it is free to register de-register the spn's at will.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply