通过本地计算机上的SQL Server Management Studio访问Azure VM上的SQL Server [英] Access SQL Server on Azure VM via SQL Server Management Studio on my local Machine

问题描述

我确定这是在某个地方，但是我找不到它，而且我的大脑也很痛.

I'm sure this is out there somewhere but I can't find it and my brain hurts.

我在Azure上有一个VM.它具有运行的SQL Server.我可以在VM上本地访问它，没问题，但是我想通过SQL Server Management Studio在我的开发计算机上对其进行管理.

I have a VM on Azure. It has SQL Server running on it. I can access it locally on the VM no problem but I would like to manage it from my dev computer via SQL Server Management Studio.

这有可能吗?我会使用什么信用?VM登录?

Is this possible and what creds would I use? the VM Login?

谢谢，R

推荐答案

您需要完成以下所有操作才能实现所需的目标:

You need to complete all of the following to achieve what you want:

• 在端口1433上为该VM添加TCP终结点-public&专用(如果需要，您可以更改公共端口).
• 配置SQL Server实例以侦听TCP.
• 在VM的本地FireWall规则中启用无法使用的TCP端口1433.
• 在SQL Server上启用混合模式身份验证
• 确保您的ISP不会阻止传出端口1433(自 2003年的SQL Slammer 起，这是大多数ISV的惯常做法.)-对于您的TCP终结点，可使用自定义的公共端口来覆盖.

• Add a TCP endpoint for that VM on port 1433 - public & private (you can change the public port if you will).
• Configure the SQL Server Instance to listen to TCP.
• Enable the incomping TCP port 1433 in the local FireWall rules of the VM.
• Enable mixed mode authentication on the SQL Server
• Make sure your ISP does not block outgoing port 1433 (a common practice for most of ISVs since 2003' SQL Slammer) - this is overridable with custom Public port for your TCP endpoint.

然后您将能够使用本地SSMS连接到Azure VM中的SQL Server.

Than you will be able to connect to the SQL Server in the Azure VM using your local SSMS.

这篇关于通过本地计算机上的SQL Server Management Studio访问Azure VM上的SQL Server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！