May 6, 2013 at 10:36 am
I have a number of jobs that fail because of a linked server message.
Executed as user: Domain\User. Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "Oracle". [SQLSTATE 42000] (Error 7303). The step failed.
Sometimes these jobs complete successfully, though they fail the majority of the time. Any ideas?
May 8, 2013 at 8:15 am
jshurak (5/6/2013)
I have a number of jobs that fail because of a linked server message.
Executed as user: Domain\User. Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "Oracle". [SQLSTATE 42000] (Error 7303). The step failed.Sometimes these jobs complete successfully, though they fail the majority of the time. Any ideas?
Please check this... http://social.msdn.microsoft.com/forums/en-US/transactsql/thread/1d90b645-0d42-430d-b2e1-9e7cb671beec/
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.November 10, 2020 at 4:19 am
I had the same issue on SQL Server 2017 (14.0.3335.7) when we changed the SQL Server Service account across all services (SQL Server, SQL Agent, SSIS, SSRS)
This what I've done to fix the issue:
I think the only outstanding step was the reboot. (The reboot reloads the com objects with its permissions included.)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply