when i run the following st using linked server its working fine but when same pasted in job and created a job on server A the job failed giving the below error message..
error :
servera$'. [SQLSTATE 28000] (Error 18456). The step failed.
sql st
from server A where linked server has been created with server B)exec server b.northwind.dbo.temp1
i have used 'useself' as the security option and set other options as default.
both the server are supporting named pipes protocol..!!!
pls help
Sanjay
Hi
If the error message includes the account with which you are trying to access the server, you do not have permission to log in to the server.
Verify the job owner permissions on the linked server, or change the job owner.
Jakus Andras MCDBA
"Sanjay" wrote:
> Hi,
> when i run the following st using linked server its working fine but when same pasted in job and created a job on server A the job failed giving the below error message..
> error :
> servera$'. [SQLSTATE 28000] (Error 18456). The step failed.
> sql st
from server A where linked server has been created with server B)> exec server b.northwind.dbo.temp1
> --
> i have used 'useself' as the security option and set other options as default.
> both the server are supporting named pipes protocol..!!!
> pls help
> --
> Sanjay
No comments:
Post a Comment