Share via

A community member has associated this post with a similar question:
why we need to run SSMS Run as administrator for accessing linked server with excel file

Only moderators can edit this content.

SQL Agent Job Fails

Rushikumar Kuntumalla 20 Reputation points
2023-10-20T06:11:40.1166667+00:00

I'm having issues with one of our SQL Server Agent Jobs which import data from an Excel sheet via linked Server. The excel file is located in the file share and not in local drive.

When I try to run the same script using normal on SSMS query window, it is running without issues but when we create a SQL Agent Job, it throwing the below error message.

Error Message:

Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server [SQLSTATE 42000] (Error 7303)

OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server returned message "Unspecified error". [SQLSTATE 01000] (Error 7412). The step failed.

I have tried with the below options but no luck.

  1. Run SSMS with run as admin
  2. Verify the path in registry level and added as below.

User's image

  1. SQL Agent Service Account is having full control on the excel file
SQL Server | Other