August 22, 2006 at 3:21 pm
I am using SQL Agent on SQL Server 2005. It is installed on a Windows 2003 Server. I installed the Agent to run as Local Systems Account.
I created an SSIS package that runs just fine under Visual Studio on the server as well as from my desktop.
When I try and have Agent run the job the following entries are entered in the Error Log:
[382] Logon to server 'APOLLO' failed (ConnAttemptCachableOp)
[298] SQLServer Error: 18456, Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. [SQLSTATE 28000]
I have looked at everything I can think of and I have supplied credentials everywhere. The owner of the job is sa.
Where am I going wrong?
August 23, 2006 at 11:34 am
Use either a domain account or a local user account for the Agent.
So long, and thanks for all the fish,
Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3
September 4, 2006 at 6:48 pm
Used a local user acct and made it equiv to admin...still doesn't work
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply