Sreenivasan Rajagopalan 18.Aug.08 01:24 PM a Web browser LC LSXAll ReleasesWindows
I am using a scheduled agent to connect to a SQl Server table in our company.When I run the agent from the workstation it runs fine.
We have a set up an Active Directory ID that we would want to use to authenticate to the SQL Server table.We want to use this ID through our scheduled agent.
When I tried to connect through the server agent we get:
ErrorRecord: HResult: 0x80040e4d
Description: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
SQLErrorInfo: 42