I have a SQL job scheduled to run every hour. It at times faisl and at times succeeds. The error message coming out is
Executed as user: GAR\sql_pginceptor01. DTSRun: Loading...
Error: -2147467259 (80004005); Provider Error: 17 (11)
Error string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
Error source: Microsoft OLE DB Provider for SQL Server
Help file: Help context: 0. Process Exit Code 1. The step failed.
The owner of the job is a local system administrator login. The owner of the ackage is the same. I heard that this will occur because of rights issue in the package. But if that is the case, why is this ocassinally happening rather than happening every one hour. Please do let me know as this is very urgent.