May 29, 2008 at 6:03 pm
I created a remote link on one of the server and running distributed query. I can run the query without any problem but one of my user cannot run it, getting error link un anonymous user error.
I added a mapping in the remote link property like. Added user name and mapped into the Account which is already on the remote server and has full rights but still user cannot access the distributed query.
Any help will be appreciated.
June 2, 2008 at 7:59 am
If you're using Windows authentication for your security, then you need to take additional steps for the distributed connection. Windows security can't "chain" to more than one computer. Look up "NT AUTHORITY/ANONYMOUS LOGON" on MSDN, and it will give you all the details.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
June 2, 2008 at 9:30 am
Check Configuring Linked Servers for Delegation
* Noel
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply