Skip to main content
To homepage To homepage

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

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