Tony, I'm not sure cause I'm vegging at home right now... but I think you have to add the linked server AND the linked server login. There's an SP called...
sp_addlinkedsrvlogin I think? It goes something like... sp_addlinkedsrvlogin 'remoteserver', 'remoteUser','remotepassword' I believe there are some other impersonation options as well. -Mark -----Original Message----- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Thursday, August 21, 2003 6:15 PM To: CF-Talk Subject: sql question im getting this error.... Server: Msg 18456, Level 14, State 1, Line 1 Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. when trying to do a query from one sql server query analyzer when referencing another one and a db on the other one.... I did sp_addlinkedserver however its barfing on a user that Im not sure where im missing...help???? tony weeg uncertified advanced cold fusion developer tony at navtrak dot net www.navtrak.net office 410.548.2337 fax 410.860.2337 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
