OLE DB provider "SQLNCLI10" for linked server error

• tmmutsetse

  Hall of Fame

  Points: 3669

  More actions

  May 17, 2016 at 4:36 am

  #310650

  Good day Experts,

  I am trying to run a job and i am getting this error.I tried to change the remote query timeout under connections of instance from 600 to higher but the error comes back still.Is it a port issue since i am using default 1433? Please help

  Job 'BA_HostDriveStatusUpdate' : Step 2, 'Exec SP' : Began Executing 2016-05-17 12:14:43

  Msg 7399, Sev 16, State 1, Line 37 : The OLE DB provider "SQLNCLI10" for linked server "xxxxxxx" reported an error. Execution terminated by the provider because a resource limit was reached. [SQLSTATE 42000]

  Msg 7306, Sev 16, State 1, Line 37 : Cannot open the table ""BA"."dbo"."HostDriveStatus"" from OLE DB provider "SQLNCLI10" for linked server "xxxxxx". [SQLSTATE 42000]

  Msg 7412, Sev 16, State 1, Line 37 : OLE DB provider "SQLNCLI10" for linked server "xxxxx" returned message "Query timeout expired". [SQLSTATE 01000]

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  May 17, 2016 at 8:26 am

  #1879550

  Check the permissions for the account that you are using for the linked server.

  Make sure that it at least is a member of the database fixed server role db_datareader.

  You may want to add additional rights as needed.

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/