SQL Prompt 9.5 table/column suggestions not working with SSMS 18.0 Azure SQL Data Warehouse

RandoMRandoM Posts: 2 New member
edited May 6, 2019 12:13PM in SQL Prompt
I am connecting to Azure SQL Data Warehouse and since upgrading to SSMS 18.0 and SQL Prompt 9.5.2,  SQL Prompt has stopped suggesting database tables. 

I have already re-installed both SSMS and SQL Prompt without success.

SQL Server Management Studio 15.0.18118.0
SQL Prompt 9.5.2.9464

auth. method: Active Directory - Universal with MFA support
Tagged:

Answers

  • ricsekerricseker Posts: 2 New member
    I'm having the same issue, downloaded SQL Prompt newest version and SSMS 18 newest version and the suggestions don't work. If I open SSMS 17 they work
  • RandoMRandoM Posts: 2 New member
    Support has let me know that SQL Prompt v9 does not support Azure auth (or anything Azure) though some of it may work. And that the team are aware that some of this functionality worked previously but unfortunately this is not currently going to get fixed.

    :(
  • ricsekerricseker Posts: 2 New member
    I can use SQL Prompt v9 suggestions  perfectly with SSMS  17.9, however the main reason to migrate to SSMS 18 is that 17.9 tends to freeze with Azure SQL Server. This is an issue that you should be resolving as many people is using Azure platforms 
  • droachdroach Posts: 1 Bronze 1
    RandoM said:
    Support has let me know that SQL Prompt v9 does not support Azure auth (or anything Azure) though some of it may work. And that the team are aware that some of this functionality worked previously but unfortunately this is not currently going to get fixed.

    :(
    If that's the case, I'd like to hear from Redgate why they've decided to snub customers that require Azure authentication.
  • reubsterreubster Posts: 3 New member
    Pretty much destroys the use case for it for me. It's helpful if I'm developing on my desktop with a local instance... otherwise not. . 
  • koenverbeeckkoenverbeeck Posts: 1 New member
    What is the status on this?
  • cgstdevopscgstdevops Posts: 1 New member
    would also like to know the status of this. Is it being worked on?
  • erichumphreyerichumphrey Posts: 1 New member
    Ditto. I need this to work.
  • Hello all,

    Just a quick update to let you know that we are aware of the Azure issues described here. Support for Azure is something that is important to us in the Prompt team & will be actively worked on soon.

    I’ll make sure I keep you updated here as this progresses.

    Tim
    Product Manager
    Redgate Software
  • InfoShovelInfoShovel Posts: 1 New member
    Hi Tim,

    Can you please give an update on this issue? SQL Prompt offers very little value in terms of development speed without this feature. Is this something you are addressing or will be in subsequent sprints?
  • LimeadeLimeade Posts: 1 New member
    We also need to make sure it will work with MFA as that is a requirement these days.
  • clansingclansing Posts: 10 New member
    Do it, please
  • CariniCarini Posts: 1 New member
    I was able to get around this issue by turning on "Enable conditional access to Azure SQL Database (EXPERIMENTAL)" under Tools -> Options -> Azure Services.  I was logging in with Azure Universal, that now that fails, but then I was able to login Windows Authentication - Password.  (still using my azure email/pass I was using in universal). 
  • clansingclansing Posts: 10 New member
    Using Universal with MFA here and that experimental feature made it worse, where I could not even connect to my database at all with that enabled
  • Another update here. The team are now actively working on improving Azure support in SQL Prompt. You'll see updates in the product over the next few releases.

    Tim
    Product Manager
    Redgate Software
  • YushaYusha Posts: 1 New member
    Still waiting. Any news?
  • TomWTomW Cambridge Posts: 108 Gold 1
    Hi Yusha,

    Unfortunately, we've been blocked by an external dependency from doing this work over the past few weeks. However, that dependency has been resolved so we should be able make progress on this soon.

    Sorry for the inconvenience.

    Software Engineer for SQL Prompt
    Redgate Software
  • emegg02emegg02 Posts: 1 New member
    With azure active directory with password, all works, with MFA, still does not work.
  • Any preliminary ETA, if at all possible, would be appreciated @TomW :) it's getting increasingly frustrating to be missing suggestions..
  • ZrethrealZrethreal Posts: 2 New member
    This seems to be still an issue
    SQL Server Management Studio 15.0.18338.0
    SQL Prompt 10.3.3.15548
    Auth: Azure Active Directory - Universal with MFA support
    Redgate can you confirm that this has still to be resolved?
  • ostandageostandage Cambridge Posts: 9 Bronze 2
    Hi @Zrethreal

    I am very sorry for the delay and inconvenience this has caused.

    We have been actively working on this recently however we have again been blocked by an external dependency. We are currently working with the vendor to resolve this. 

    Thanks, 

    Owen
    Software Engineer
    SQL Prompt
  • ZrethrealZrethreal Posts: 2 New member
    ostandage said:
    Hi @Zrethreal

    I am very sorry for the delay and inconvenience this has caused.

    We have been actively working on this recently however we have again been blocked by an external dependency. We are currently working with the vendor to resolve this. 

    Thanks, 

    Owen
    Thank you for the reply @ostandage. I'm managing at the moment but it is inconvenient - so good to know that it is being worked on :-)

    Br
  • RishabRishab Posts: 1 New member
    Ok so here's the workaround I figured out for the time being, specifically for myself. Please note that this may be company-specific hence might not work for you, but here it is:

    Instead of authenticating my SQL Server "Connect to Database Engine" via "Azure Active Directory - Universal with MFA", I connected via "Azure Active Directory - Password". I used my enterprise's windows email username and password, and the Column Picker was no longer greyed out. I hope this helps the handful of you who are working under the same enterprise configurations as me!
Sign In or Register to comment.