如何使用Sqlserver中的Jobs将数据从本地数据库插入到远程数据库
问题描述：
我创建了存储过程，用于在Sqlserver中将数据从本地插入到远程数据库。我直接执行时工作正常，但是当我通过Job执行时它失败了。
注意：源数据库：sqlserver2012，目标数据库：Sqlserver2005
如何解决此问题。 b $ b
请尽早回复。
先谢谢。 ...
Hi,
I have created Stored Procedure for insert data from local to Remote database in Sqlserver. It's working fine when i execute directly, but It's failed when i have executed through Job.
Note : Source Database : sqlserver2012, Destination Database : Sqlserver2005
How to Resolve this Issue.
Please reply as early as possible.
Thanks in Advance....
答
执行作业时出错。错误是作为用户执行：NT SERVICE \ SQLSERVERAGENT。
用户'NT AUTHORITY \ANONYMOUS LOGON'登录失败。[SQLSTATE 28000]（错误18456）。步骤失败。
解决方案：
登录链接服务器（远程服务器）后，作业运行成功。
对于登录链接服务器，执行以下程序：
EXEC sp_addlinkedsrvlogin'servername'，'false' ，NULL，'用户名'，'密码'
I got error when executing the job. The error is "Executed as user: NT SERVICE\SQLSERVERAGENT.
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. [SQLSTATE 28000] (Error 18456). The step failed."
The solution :
After login linked server (Remote server), the job is running successfully.
For login linked server execute the below procedure :
" EXEC sp_addlinkedsrvlogin 'servername', 'false', NULL, 'username', 'password' "