July 19, 2010 at 4:36 am
I have sql server 2005 servers set up as linked servers. The problem is if I access the link server from the server to which it is linked, it works fine where as If I access from other server it says login failed for anonymous user. Example . If A is linked to B. Then the qry
select * from A.db.dbo.tbl succeeds if executed from B where as it gives the above error if run from server C. All server are in same domain and are connected.
The security used for linked server is: be made using login's current security context.
I have checked the login. The same exist on all three servers with sysadmin permission.
Regards,
[font="Verdana"]Sqlfrenzy[/font]
July 19, 2010 at 12:14 pm
Hi
On Server C change the Linked Server security to the option " Be made using Login's current security context" instead of using the option " Be made without using a security context (Anonymous authentication)"
Thank You,
Best Regards,
SQLBuddy
July 19, 2010 at 10:58 pm
linked server is on A and am just accessing it from server C.
Regards,
[font="Verdana"]Sqlfrenzy[/font]
July 20, 2010 at 1:30 am
got it...a known isu..must have googled before posting ..
Regards,
[font="Verdana"]Sqlfrenzy[/font]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy