Forum Discussion

RetiredDude's avatar
RetiredDude
Copper Contributor
Sep 18, 2022

Linked server between SQL Server Express and Azure

Local environment: Dell Inspiron, Windows 10, SSMS version 18.12.1.

I created an ODBC system DSN to connect to a remote SQL server hosted by Azure.  I created a linked server in SSMS using that DSN.  I can see the database and expand the tables.  I can see the objects.  I cannot run selects against the tables.

I created an Access database and linked tables using that same DSN.  It worked.  I can read the contents of the tables on the linked Azure hosted SQL server.

Since I can read the tables with Access, I have to think that the server side is not blocking me.  It must be the SSMS on my local machine.

Any ideas?

  • olafhelper's avatar
    olafhelper
    Bronze Contributor
    Sep 19, 2022
    I cannot run selects against the tables.

    RetiredDude , and that means what in detail? Do you get an error message and if, which one?

    How does your SQL query look like?

    You have to provide much more details.

     

    Olaf

Resources