September 24, 2003 at 2:16 pm
I am trying to run a stored procedure that sends the results through the sp_sendmail stored procedure. The query is done using a link server connection. I can run the query without any problems. When I try using the query with the xp_sendmail as a stored procedure I grt the following error: Executed as user: ODBC error 7410 (42000) Remote access not allowed for Windows NT user activated by SETUSER. Process Exit Code 0. The step succeeded.
Charlene
September 29, 2003 at 12:00 pm
This was removed by the editor as SPAM
September 29, 2003 at 12:59 pm
Just a shot in the dark here, but it sounds like the user the job is running under does not have the necessary remote access to the linked server. Have you attempted these actions manually logged in as the user the job runs under?
Chris
Doesn't know nuthin about nuthin, but don't tell nobody. 😉
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply