question

alice01 avatar image
0 Votes"
alice01 asked CarrinWu-MSFT commented

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


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
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @alice01, we have not get a reply from you. Did any answers could help you? If there has an answer helped, please do "Accept Answer". If not, please let us know. By doing so, it will benefit for community members who have this similar issue. Your contribution is highly appreciated. Thank you!

0 Votes 0 ·

1 Answer

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.