Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Feb 22, 2012 04:51 AM by Mamba Dai - MSFT
Feb 20, 2012 01:33 PM|LINK
Hi guys I'm trying to get a table fill through a job.
When I execute the query in sql-mode it works.
But when I try it in a job I get this error:
Executed as user: NT AUTHORITY\SYSTEM. The OLE DB provider "ADSDSOObject" for linked server "ADSI" reported an error. The provider did not give any information about the error. [SQLSTATE 42000] (Error 7399) Cannot initialize the data source object of OLE
DB provider "ADSDSOObject" for linked server "ADSI". [SQLSTATE 42000] (Error 7303).
tried to disable firewall didn't work.
Feb 22, 2012 04:51 AM|LINK
SQLSTATE 42000] (Error 7399
Executed as user: NT AUTHORITY\SYSTEM
This problem occurs because the login account does not have full access to the temporary folder of the SQL Server startup account. The linked server query runs in the context of the login account. If you run a linked server query, SQL Server tries
to create a temporary file data source name (DSN) in the temporary folder of the SQL Server startup account.
How to solve this problem please go through this KB:
Hoep it helps!