thanks mark, i did the addlinkedserver and addlinkedserverlogin sp's and that didnt do it..it was mixed mode vs. sql auth only and so i made it sql auth and now its all good :)
thanks anyhew!! t w -----Original Message----- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] Sent: Thursday, August 21, 2003 7:36 PM To: CF-Talk Subject: RE: sql question 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
