Linked server Intellisense suggestions with Azure DB

JGoulet89

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

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?

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?

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?

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