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).
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:
lordplazikov...
Member
195 Points
319 Posts
Linked servers
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.
Mamba Dai - ...
All-Star
23531 Points
2683 Posts
Microsoft
Re: Linked servers
Feb 22, 2012 04:51 AM|LINK
Hi,
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:
http://support.microsoft.com/kb/814398
Hoep it helps!
Feedback to us
Develop and promote your apps in Windows Store