To homepage To homepage
Solved

Can you connect SQL Server database to ODX via a linked server?

  • 6 March 2024
  • 1 reply
  • 30 views
anders.e.jonsson
Rank
Userlevel 1
Badge +1

Hi,

A customer running version 6536.1 has provided us with a SQL Server database on a linked server (server L) as source, but we haven´t managed to connect to it so far.
There is no problem running queries to that database on server L from management studio, when the query is run from the context of a database on server/instance where the linked server is added (server TX). This is a different windows server than the linked server.

The appserver with the ODX-service is on yet another Windows server. The ODX database resides on server TX. Connecting to the ODX db and the TimeXtender MDW’s on server TX works fine.

Is it possible to use a linked server as a source? If so, how should the server name(s) be specified in the connections settings in the portal?

BR
Anders

icon

Best answer by Christian Hauggaard 6 March 2024, 15:14

View original
Anders

1 reply

Christian Hauggaard
Rank
Userlevel 6
Badge +5

Hi @anders.e.jonsson 

Connecting to linked servers using an ODX data source is not currently supported. A potential workaround could be to create a database with views targeting tables in the linked server and connecting to that database.

Reply


Terms and ConditionsCookie settings