September 30, 2010 at 10:42 am
I am getting the following error while trying to run the distributed queries on the client machine.
select * from ServerName.master.dbo.sysdatabases
When I log on with a particular account, I have no problem but when I use my account I get this error.
Three machines are included in this distributed query.
Machine A ( Client machine)
Machine B ( Linked setup)
Machine C ( source data)
Linked server is setup with a Security option like
"Be made using the login's current sefcurity context"
My account is a domain account and have access to Machine C.
Any help will be appreciated.
October 1, 2010 at 1:14 am
The error sounds like a Kerbeos authentication issue, with regards to delegation and the setting up of correct SPNs.
Can you change the linked server to make the connection as a specific account, IE. yours? Does your account have permissions to this other server (that you are trying to connect to)?
October 1, 2010 at 9:13 am
SPN was not setup properly. It's fixed and working fine. Thanks.
October 10, 2010 at 2:08 am
Could you plase share what steps you took to resolve the SPN issue as I am facing the same problem too.
Thanks in advance,
Manu
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply