[Solved] Can't use SQL server manageer to access Azure SQL from Visual Studio 2022 - S7an Insights

Breaking

S7an Insights

生活 × 技術 × 分享 讓複雜的問題,有條理地解決。

2023年4月14日 星期五

[Solved] Can't use SQL server manageer to access Azure SQL from Visual Studio 2022

 As the title, I have created an Azure SQL for a practice.

Tutorial: ASP.NET app with Azure SQL Database - Azure App Service | Microsoft Learn



But when I try to access Azure  SQL via VS2022 SQL server manager, there is nothing under my account.



I have confirmed the Azure SQL is running well, and the website is too.

So, try another way to access Azure SQL, [Server manager] -> [Connect Azure]




Then [select the Azure DB ] -> Right click [Explore in SQL server Object manager] --> then you can see the Azure DB in SQL server manager.




Ref:

Working with Visual Studio and SQL Azure databases (sqlshack.com)

How to connect to azure SQL server using visual studio - Stack Overflow

沒有留言:

張貼留言

問題沒有大小或好壞