September 27, 2005 at 8:11 am
I've got a SQL Server Agent job (that is part of a DTS package) that is failing. When I look at the Job History (show step details) this is what I have:
Executed as user: MYDEVSQL\SYSTEM. DTSRun: Loading... Error: -2147217843 (80040E4D); Provider Error: 18456 (4818) Error string: Login failed for user 'OURDOMAIN\MYDEVSQL$'. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0. Process Exit Code 1. The step failed.
(I've changed some specifics to protect the innocent.)
In the SQL Server Agent properties
--> Connection --> SQL Server connection --> Use Windows Authentication is selected.
Any advice? Thanks.
September 27, 2005 at 10:47 am
Try the two links below for how to configure SQL Server Agent permissions to perform DTS automation. You need to install SQL Server Agent with a service account with the correct permissions. Hope this helps.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_xp_aa-sz_4jxo.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_xp_aa-sz_8sdm.asp
Kind regards,
Gift Peddie
Kind regards,
Gift Peddie
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply