Options

Linked server Intellisense suggestions with Azure DB

JGoulet89JGoulet89 Posts: 2 New member
in SQL Prompt
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
Tagged:
· Share on Twitter

Answers

  • Options
    Victoria WVictoria W Posts: 341 Gold 2
    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?
    Kind regards

    Victoria Wiseman | Redgate Software
    Have you visited our Help Center?
    · Share on Twitter
  • Options
    JGoulet89JGoulet89 Posts: 2 New member
    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?
    · Share on Twitter
  • Options
    Ben_PBen_P Posts: 224 Silver 2
    edited October 20, 2023 4:49PM
    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?


    · Share on Twitter
Sign In or Register to comment.