question

JacobBillUS-7408 avatar image
0 Votes"
JacobBillUS-7408 asked OuryBa-MSFT edited

Azure Data Studio - Unable to view user properties

When I use SSMS connecting to on prem SQL Server and perform the following action, I get the ability to view user info (specifically Securables).
<Database>/Security/Users/<User>/right click and properties

When I use SSMS or Azure Data Studio to connect to an Azure SQL DB, I get the following error.

Cannot Show requested dialog (SqlMgmt)
- The 'DefaultLanguage' property is not supported on Microsoft Azure SQL Database.
(Microsoft.SqlServer.Smo)


Has anyone experienced this issue before? If so, how did you resolve it?

sql-server-generalazure-sql-database
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi JacobBillUS-7408,

Welcome to Microsoft Q&A.
Your issue is also related to Azure SQL Database. So I add the tag azure-sql-database to this issue, hoping to get more help.

Best Regards,
Amelia

0 Votes 0 ·
OuryBa-MSFT avatar image
0 Votes"
OuryBa-MSFT answered OuryBa-MSFT edited

Hi @JacobBillUS-7408 Thank you for posting your question on Microsoft Q&A. Both ADS and SSMS use the same user properties page, so it’s expected that both would fail for the same reason when connecting to an Azure DB. The dialog implementation is actually coming from SSMS.
SSMS does not have the Properties menu item on the user in its context menu so this is likely an unsupported feature. This could be a bug in the ADS Database Administration extension to show the Properties menu item incorrectly on the user node when connected to a Azure SQL DB instance.
I will check with our product group if a fix should be implemented or use a query to view users properties.

Hope that helps

Regards,
Oury

· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks for the reply!

1 Vote 1 ·

Hi @JacobBillUS-7408 the fix will be to remove the Properties menu item from the user node when connected to an Azure SQL DB. The user should use queries or some other mechanism to actually get the user properties they want to retrieve.

Regards,
Oury

1 Vote 1 ·

Hi @JacobBillUS-7408 To follow up on this - Our product group has published a new version of the extension that removes the properties menu option for objects that aren’t supported on Azure such as Login. So if you update to 0.0.3 you shouldn’t see that any longer.

Regards,
Oury

0 Votes 0 ·
ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered JacobBillUS-7408 commented

Which version of SSMS do you have? When I test this in SSMS 18.9.2, I don't see an Properties option for users in my Azure SQL DB. The same is true for Azure Data Studio 1.31.0. I guess that they removed this option since it is not working.

The way to resolve this is to run queries to find the information. Since I never user the UI for these kind of things myself, I don't know exactly what you are looking for.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SSMS v18.9.1
Azure Data Studio 1.31.0

I'm able to see the "right-click" properties in Data Studio after installing the following extension.
Database Administration Tool Extensions for Windows

My problem in Data Studio = when I select properties, I receive the error message in the original question.

I do have a query for viewing User-Securables, however I do like using the GUI for this too.

0 Votes 0 ·