Skip to main content
To homepage To homepage
Solved

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

  • March 6, 2024
  • 1 reply
  • 68 views
anders.e.jonsson
Contributor
Forum|alt.badge.img+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

Best answer by Christian Hauggaard

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.

View original
Anders
    Did this topic help you find an answer to your question?

    1 reply

    Christian Hauggaard
    Community Manager
    Forum|alt.badge.img+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.

    anders.e.jonsson
    1 person likes this
    • anders.e.jonsson
      anders.e.jonsson

    Reply


    Most helpful members this week

    Terms and ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings