October 28, 2010 at 11:27 am
I am trying to do link server with windows at. login local and it is not working, anyone knows why?It works with SQL account
October 28, 2010 at 11:30 am
One of two reasons is most likely:
Lack of rights. If it's a local Windows login, it probably doesn't have any rights at all on the linked server.
Chain Windows Authentication. Windows can only pass rights from one machine to one other, the second cannot then pass them on to a third. Take a look at "kerberos" online to find solutions for this.
Without an actual error message, et al, those are the best guesses I can give you.
- 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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply