SQL 2014 LinkServer response issue

• nikhil.desai1

  SSCommitted

  Points: 1948

  More actions

  January 26, 2015 at 6:41 am

  #296935

  Hi,

  There is one link server created on SQL Server 2014 which connects to AS400 server. There are 3-4 SQL jobs executes after every 4-5 secs which uses these link server to fetch data from AS400. This linkserver does not response after every 38 hours.

  We did two testing:

  1. After restarting the SQL Agent , we did test connection of Linkserver but then also it wasn't

  responding

  2. After restarting SQL Server Database Engine server the link server started working properly.

  We are using SQL Server 2014 standard Edition.

  64-bit ODBC data source administrator with iSeries Access ODBC driver is used.

  Link server provider - Microsoft OLEDB Provider for ODBC driver

  Product Name : AS400

  Please let me know how to over come this issue without restarting the SQL Server Services.

  Thanks and Regards,

  Nikhil P Desai