Share via

Sql Server Agent Job Failed Error 7330 and Error 7412

  • Article

Question

Tuesday, October 20, 2015 3:21 PM

we have this new 2012 box. one of the job failed occasionally with same error:

Message
Executed as user: USA\XXXXXXXX. Insert String Insert into dbo.TargetTable  Select *  From   Dbo.SourceTable [SQLSTATE 01000] (Message 0)  Cannot fetch a row from OLE DB provider "SQLNCLI11" for linked server "Prod". [SQLSTATE 42000] (Error 7330)  OLE DB provider "SQLNCLI11" for linked server "Prod" returned message "Query timeout expired". [SQLSTATE 01000] (Error 7412).  The step failed.

The issue is we are not pointing to prod in this query at all.

can someone please help me with this error.

I have created global proxy account. I have also executed: sp_configure'remote query timeout',0 ;

;

GO

Please mark as helpful and propose as answer if you find this as correct!!! Thanks,Dia Agha .

All replies (1)

Wednesday, October 21, 2015 8:53 AM
What security context are you using in linked server?

if it is "Current Securiity Context" then the Service account running SQL Agent needs to be granted permission on the linked server.

If you have listed specific accounts to map, then this account needs to be mapped as well.

Right-click the linked server, click properties and go to the security tab to see this.

Use the services applet to view the SQL agent service account

Please click "Mark As Answer" if my post helped.