Problem LINKED SERVER

Last Post 01 Mar 2006 07:15 AM by sahrisoror. 3 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
sahrisoror
New Member
New Member

--
01 Mar 2006 03:10 AM
hi,
when i execute a SP on a linked server, i have this error:
Server: Msg 18452, Level 14, State 1, Line 1
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

what can i do please? before it functioned normally.
regards
sahrisoror
New Member
New Member

--
01 Mar 2006 07:15 AM
i use it in a job. when i call the SP directly in the sql analyser (with sa account), the sp functions. But when i call the same SP through a job, i have this error (i have the same error when i execute the SP on the sql analyser with nt account).
regards
sahrisoror
New Member
New Member

--
01 Mar 2006 11:57 PM
the linked server (with jobs...) function before without any pb. All what i changed is the sql agent, it's at the system account
sahrisoror
New Member
New Member

--
02 Mar 2006 12:44 AM
effectivlly, it was the pb of the sql agent that i have changed. Thanks a lot rm!!
You are not authorized to post a reply.

Acceptable Use Policy