且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

在Azure SQL托管实例中db_owner无法访问数据库

更新时间:2022-04-02 21:33:52

你好,

Hello,

If you try to access the Managed Instance from a SSMS installed on VM on the same network you will be able to connect/authenticate successfully..

If you try to connect from a SSMS installed on a host located on-premises, on the routing table that is added to the subnet where SQL Managed Instance is deployed, add another route to the routing table for your on premise subnet with next hop Virtual Network Gateway, After that, you will be able to connect from SSMS.


Hope this helps.


Regards,

SQLCoffee.com 跨度>


Alberto Morillo
SQLCoffee.com