September 30, 2015 at 2:32 pm
i am using linked servers to manage some hosted servers
originally they were using a username and password on all the servers.
Now they have changed the servers to window auth only.
My ssms works find with it set to local context
but this is in a job which has errors for every server
begin try
EXEC sp_testlinkedserver @InstanceName
end try
begin catch
--l loop past the server
end catch
i tried execute as my login several places to know avail says my login does not exist on those servers
I know i can add a user to their server but that requires a lot of paperwork
I don't want to have to run the reports everyday from my desktop
So if someone has another way of testing for linked servers
October 1, 2015 at 1:43 am
Sounds like a kerberos issues.
Are all the servers in question running their services via AD service accounts? If so have they all been trusted for delegation?
October 1, 2015 at 7:44 am
yes they Ad services but the trusted for delegation would be a change on their side which i cant do
October 1, 2015 at 7:49 am
Ask your sysadmins to check all the service accounts then to ensure they are trusted for delegation.
Then ensure the service accounts have rights to create SPN's and that all the SPN's for the servers and accounts in question have been setup.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply