azure data factory - many subscriptions error

Question

azure data factory - many subscriptions error

Müller, André 71

Hi, i´ve multiple subscriptions and tenants under my account. After signin i can see only subscriptions for one tenant and for the other one not. Therefor i get an error message:

Using MS SQL Server Management Studio will work, hence it´s not related to any azure subscription settings.

Thx for any feedback

MartinJaffer-MSFT 26,161 Reputation points

2022-06-02T19:35:44.597+00:00

Hello @Müller, André and welcome to Microsoft Q&A.

I'm trying to understand your ask, but I am confused. You are using SSMS and having trouble listing your subscriptions. How does this relate to Azure Data Factory?
Synapse I might understand, because there are dedicated SQL pools for SSMS to query.

Does my question make sense, or am I having a dumb moment?
Müller, André 71 Reputation points

2022-06-03T04:40:44.693+00:00

Hi,

sorry for the missing information. I encounter the given issue using Azure Data Studio (refer to screenshot). But i can connect to the error throwing tenant via SSMS.
HimanshuSinha 19,637 Reputation points Microsoft Employee Moderator

2022-06-07T19:56:53.55+00:00

Hello @Müller, André ,
As I understand that you are using Azure Data studio ( ADS) to connect database etc .Also I undetsand that you are able to make the connecttion using SSMS but not ADS.
Can you please elaborate as to what is the Databse you are trying to connect ? Is it SQL Server or something else .

We will wait to hear from you .
Thanks
Himanshu
Müller, André 71 Reputation points

2022-06-08T18:04:07.557+00:00

Hi, yes that´s correct. The database is Azure SQL database. In detail i have two azure sql databases in different tenants and hence subscriptions. I can connect to both via SSMS MFA but only to one tenant/subscription via ADS. For the second one i get the error message above (intial question).

thx in advance