All geek questions in one place

Access SQL Server on Azure VM through SQL Server Management Studio on my local machine

I'm sure it is somewhere out there, but I cannot find it, and my brain hurts.

I have a virtual machine on Azure. It runs SQL Server. I can access it locally in a virtual machine without any problems, but I would like to manage it from my development computer through SQL Server Management Studio.

Is this possible and what kind of loans do I use? Logging in to VM?

Thanks R

+6
source share
3 answers

To achieve the desired result, you must perform all of the following:

  • Add the TCP endpoint for this virtual machine to port 1433 — public and private (you can change the public port if you want).
  • Configure an instance of SQL Server to listen on TCP.
  • Enable incompatible TCP port 1433 in the local FireWall rules of the virtual machine.
  • Enable Mixed Mode Authentication on SQL Server
  • Make sure your ISP does not block outbound port 1433 (a common practice for most third-party software vendors since 2003, “SQL Slammer” ) is an overridden user public port for your TCP endpoint.

How can you connect to SQL Server in Azure VM using the local SSMS.

+20
source

Faced with this problem with Azure VM, I cannot connect to the SQL server. All steps described in the answer above, but not successful, have been completed.

It started working when I set a specific port for TCP / IP.

So, open SQL Server Configuration Manager, find the TCP / IP protocol for your instance, open "Properties" and set the port to 1433 in the IPAll section.

+3
source

Instead of SSMS, you can also use Powershell to test connectivity to SQL Server on Azure VM. A detailed powershell script is located at the following link -

http://sanganakauthority.blogspot.in/2014/02/connecting-to-sql-server-virtual.html

This will save you from installing SSMS on the machine with which you want to connect to the SQL Server virtual machine.

-3
source

Source: https://habr.com/ru/post/924193/

More articles:


All Articles