Unable to run oracle datasource dtsx file in sql server job agent.

Alice01 46 Reputation points
2021-04-28T09:32:06.563+00:00

SSIS dtsx package works fine while using oracle data provider for OLEDB as data source.
we are getting error while executing the dtsx package in SQL Server Job Agent.

Error:
The job failed. Unable to determine if the owner (PC\Administrator) of job test2 has server access (reason: Could not obtain information about Windows NT group/user 'PC\Administrator', error code 0x534. [SQLSTATE 42000] (Error 15404))

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,416 questions
{count} votes

1 answer

Sort by: Most helpful
  1. CarrinWu-MSFT 6,841 Reputation points
    2021-04-29T06:45:32.46+00:00

    Hi @Alice01 ,

    Welcome to Microsoft Q&A!

    Have you ever changed the server name or NT Account before? For example, you changed the hostname of a Windows server with SQL Server already installed. Internally SQL Server still shows the old hostname this must be dropped manually. Otherwise your SQL Server maintenance plan jobs fail with this error. Please refer to Fixing Maintenance Plan Error code 0x534 to get more details.

    Best regards,
    Carrin


    If the answer is helpful, please click "Accept Answer" and upvote it.
    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 No comments