SSDT - Publish script for users from external provided not generated correctly

Question

Hi everyone,

I created some users using this syntax:

CREATE USER [MY_USER] FOR EXTERNAL PROVIDER;

After a schema compare using Visual Studio 2019 Data Tools and generating a script to publish the changes I got this generated:

CREATE USER [MY_USER] WITHOUT LOGIN;

Which is not the expected behaviour.

Is this a limitation or am I missing some configuration?

Answer 1

Hi @Paul Hernandez , welcome to Microsoft Q&A forum.

I tried to follow the steps mentioned by you and was able to reproduce the issue exactly as you mentioned.

I was trying to look for solution and I found a similar issue logged as below:

Azure SQL Drop and Create AAD User During Every Deploy - FOR EXTERNAL PROVIDER

Solution of it mentioned to install latest versions of VS and SSDT. After I updated both and tried to generate the script I was able to generate it properly. I then ran the script successfully on target database as well. Please check the below screenshot for the same.

You can go to Visual Studio Installer and update the VS and SSDT. Below is the link for SSDT update:

SSDT for Visual Studio 2019

Please let me know if this helps or else we can discuss further.

----------

If answer helps, please mark it 'Accept Answer'

Answer 2

Hi @AnuragSharma-MSFT ,

many thanks for the quick support. Upgrade VS and the Data Tools to the following version has solved the issue as proposed:

Cheers,
Paul