How can we help you today? How can we help you today?

Linked server Intellisense suggestions with Azure DB

Hello, 
I have the latest version of SQL Prompt installed and I am not seeing any suggestions with the IntelliSense when I go query the linked server we have between our SQL Server (Windows server 2019 Standard 10.0) and our Azure DB for D365. We do have other linked server between 2 SQL Servers and it's working fine, so I was wondering if the feature was supported with an  Azure DB.
Thank you for you time
Jon
0

Comments

4 comments

Sort by
  • Victoria W
    Hi JGoulet89

    Please can you try disconnecting from the server and reconnecting to see if anything happens? Also, if you click refresh suggestions in the SQL Prompt menu, does anything change? 

    Which version of SSMS are you running?
    Victoria W
    0
  • JGoulet89
    Hello, I did tried all those suggestions but it doesn't work. We have :
    SQL Server Management Studio 15.0.18369.0
    SQL Server Management Objects (SMO) 16.100.46041.41
    Microsoft Analysis Services Client Tools 15.0.19342.0
    Microsoft Data Access Components (MDAC) 10.0.19041.3208
    Microsoft MSXML 3.0 6.0 
    Microsoft .NET Framework 4.0.30319.42000
    Operating System 10.0.19045

    The Azure DB of the linked server is not an SQL standard DB it's a virtual network I believe so maybe that's why it doesn't work?
    JGoulet89
    0
  • Ben_P
    Hi @JGoulet89,

    SQL prompt supports the following Azure platforms:
    • Azure SQL Database
    • SQL Server on Azure VM
    Just doing some testing on this as well, which Provider are you using for the linked server?


    Ben_P
    0
  • jnnguyen
    Was there a resolution to this issue?  I'm also trying to access an Azure SQL DB via linked server on SQL Server and it's not working.  I'm using SSMS 20.0.70.0 and SQL Prompt 10.14.18.8999
    jnnguyen
    0

Add comment

Please sign in to leave a comment.