Remote connection Azure SQL Server not showing All databases

Question

When I connect my Azure SQL Server using Azure portal then it shows me all databases (shown in the screenshot1)

But when I connect to the same server using SSMS inside Azure VM then it shows only one database (shown in the screenshot2)

Please someone help me in this issue

Probably your user doesn't have read access to all the databases but to only one — Francesco Mantovani, May 25 '21 at 07:56
No, I am the owner of the subscription, the server, and the databases. everything on this account — Muhammad Waheed, May 25 '21 at 16:36
Hi @Muhammad Waheed, please correct me if I understand you wrong in the answer. — Joseph Xu, May 27 '21 at 01:00

score 3 · Accepted Answer · answered May 26 '21 at 07:08

3

I think you'd better check the Options settings, did you specify the db name. If so, you will only can see specified db, not all.

answered May 26 '21 at 07:08

Joseph Xu

1 Answers1