July 12, 2022 at 10:36 am
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?
July 13, 2022 at 11:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
July 19, 2022 at 9:29 am
This was removed by the editor as SPAM
July 20, 2022 at 9:39 am
This was removed by the editor as SPAM
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply