I got a linked server to retrieve information from our Active Directory. Using a stored procedure that accesses the linked server I update a table. The procedure works!
But when I try to run it from a task, it does not work.
Does someone know, which permission has to be configured and where?
Depending on the impersonation defined on the linked server, the service account running SQL Server Agent needs to have access to the Active directory information. Normally this is done by using a domain account as the service account for SQL Server Agent.Jens K. Suessmeyer
http://www.sqlserver2005.de
No comments:
Post a Comment