How to setup Linked Server from SQL Server Express 2019 to Sage Line 50

• Weegee71

  SSChasing Mays

  Points: 607

  More actions

  July 12, 2022 at 10:36 am

  #4062040

  Hi there

  We have a Sage Line 50 Reports application located on one of our servers. This has been setup on our server as ODBC System DSN (Screenshots attached)

  Now Im trying to set up a linked server from this SageLine50 to SQL Server Express 2019 using the following programatically:

  EXEC sp_addlinkedserver

  @server='SageLine50Reports',

  @provider='SQLNCLI',

  @datasrc='ChrisSQL,1433',

  @catalog='SageLine50Reports',

  @srvproduct='';

  GO

  So catalog refers to the System DSN created which is SageLine50Report

  I then add a user to this linked server.

  Now, I then refresh my linked servers and see the SageLine50Reports linked server (see attached screenshot)

  However when I try to connect to it, I get the following error message:

  TITLE: Microsoft SQL Server Management Studio

  ------------------------------

  Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

  For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&LinkId=20476

  ------------------------------

  ADDITIONAL INFORMATION:

  An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

  ------------------------------

  TCP Provider: The wait operation timed out.

  (Microsoft SQL Server, Error: 258)

  For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-258-database-engine-error

   

  What am i doing wrong here?

   

   

   

  Attachments:

  You must be logged in to view attached files.

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  July 13, 2022 at 11:10 am

  #4062687

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.