Share via

SSIS task through SQL Agent showing OLEDB 16.0 not registered after install

Thomas Davies 20 Reputation points
2024-04-30T09:09:43.8766667+00:00

Hi all,

we're currently having issues trying to have a job run on a schedule via SQL Agent using the OLEDB 16.0 64-bit connector using an excel file. The job runs fine locally in Visual Studio, where I have the 64-bit OLEDB 16.0 installed. However when we try to run the job via a SQL agent schedule we get the class not registered error message after the job fails. It is definitely installed on the server, the job is running through a proxy which has full permissions to the folder and excel file.

Kind of at a loss as to what could be the issue, we have tried using the 32-bit (uninstalled the 64-bit and replaced it), but had the same issue even with selecting the 32-bit runtime option on the SSIS package.

Any help on how to get this sorted would be great.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,868 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,462 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Umar 160 Reputation points
    2024-04-30T09:12:41.0566667+00:00

    Subject: Re:SSIS task through SQL Agent showing OLEDB 16.0 not registered after install

    Dear Thomas Davies,

    Thank you for reaching out to us with your question regarding the SSIS task through SQL Agent showing OLEDB 16.0 not registered after install. I understand that you are having issues running a job on a schedule via SQL Agent using the OLEDB 16.0 64-bit connector with an Excel file. I'm here to help.

    Firstly, please ensure that the SQL Server Agent service is running under an account that has the necessary permissions to access the 64-bit OLEDB 16.0 provider. You can check this by going to SQL Server Configuration Manager > SQL Server Services > SQL Server Agent, and then check the 'Log On As' column.

    If the issue persists, you may need to install the Access Database Engine 2016 Redistributable on the server where the SQL Agent service is running. This will register the necessary OLEDB 16.0 components on the server. You can download the Access Database Engine 2016 Redistributable from the official Microsoft website.

    After installing, please restart the SQL Server Agent service and try running the job again.

    If you still encounter issues, please let me know and we can explore further troubleshooting steps.

    Best regards,

    Umar

  2. ZoeHui-MSFT 33,386 Reputation points
    2024-05-06T02:19:10.93+00:00

    Hi @Thomas Davies,

    You may try to install the Microsoft.ACE.OLEDB Provider for Both 64-bit and 32-bit.

    Here is a blog you may take a reference.

    Remember to restart the machine and run the package for a try.

    Regards，

    Zoe

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments