Select query on a different sql server

When I run a sql query to select records from a db / table that resides on a different server from the one I am connected to, I get the error :
NT AUTHORITY\ANONYMOUS LOGON

I am logged in with my windows credentials and I have access to both th servers.
TrialUserAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Aneesh RetnakaranDatabase AdministratorCommented:
Seems like the linked server is not setup properly , if you have permissions on the other server then you can update the linked server configuration to inherit the access.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
TrialUserAuthor Commented:
could you please elaborate. how do i do that? Thanks
0
Aneesh RetnakaranDatabase AdministratorCommented:
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

TrialUserAuthor Commented:
One of the SQL server is 2012 and the other 2008 would that cause any problems?
0
Aneesh RetnakaranDatabase AdministratorCommented:
Never tried that, but it shouldn't be an issue; the issue here is the permission.
0
Aneesh RetnakaranDatabase AdministratorCommented:
We use SPNs on all our environments
0
Guy Hengel [angelIII / a3]Billing EngineerCommented:
are the 2 sql servers part of the same domain?
is your login (windows login) also defined on the other server?
what is the linked servers configuration in the login mapping tab?
is the local sql server service account "local system" or a domain account?
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.