Hi all,

I sp_addlinkedserver to link a remote server on diff domain.
I try to call a sql job on that remote server. this is the syntax:

EXEC [mysql1].msdb.dbo.sp_start_job @job_id =
'0999B139-83D5-4CFF-9A1E-2BD2C127E7F8'
,@server_name = mysql1'


I got an error says: logon failed for use /

Any ideas?

Thanks in advance

Report this post to a moderator

I doubt if your linked server is configured properly in the first place. How
did you setup the linked server? Did you run sp_addlinkedsrvlogin, after
running sp_addlinkedserver?

Can you post the commands you used to create the linked server?

--
HTH,
Vyas, MVP (SQL Server)
SQL Server FAQ, articles, code samples, interview questions and more @
http://vyaskn.tripod.com/




"new" <henry_lin@yahoo.com> wrote in message
news:ONGQqGKcCHA.2376@tkmsftngp10...
Hi all,

I sp_addlinkedserver to link a remote server on diff domain.
I try to call a sql job on that remote server. this is the syntax:

EXEC [mysql1].msdb.dbo.sp_start_job @job_id =
'0999B139-83D5-4CFF-9A1E-2BD2C127E7F8'
,@server_name = mysql1'


I got an error says: logon failed for use /

Any ideas?

Thanks in advance

Report this post to a moderator