Avatar of TrialUser
TrialUserFlag for Afghanistan asked on

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.
Microsoft SQL ServerMicrosoft SQL Server 2008

Avatar of undefined
Last Comment
Guy Hengel [angelIII / a3]

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Aneesh

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
TrialUser

could you please elaborate. how do i do that? Thanks
Aneesh

ASKER
TrialUser

One of the SQL server is 2012 and the other 2008 would that cause any problems?
Your help has saved me hundreds of hours of internet surfing.
fblack61
Aneesh

Never tried that, but it shouldn't be an issue; the issue here is the permission.
Aneesh

We use SPNs on all our environments
Guy Hengel [angelIII / a3]

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?
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.