question

anthonyclarke-5616 avatar image
1 Vote"
anthonyclarke-5616 asked OuryBa-MSFT commented

Unable to remotely access SQL server 2019 on Azure Virtual Machine

Hello,

I am trying to trying to connect to SQL server on the Azure Virtual Machine remotely through my local SSMS but, I am not able to connect,
it says server not reachable ,

What I have tired is -
Open port on VM network configuration ,inbound and outbound
tried Win 10 Pro firewall port open ,inbound and outbound

set SQL server configuration manager IP address to 1433 to all
enabled named pipe configuration

Still not able to connect.


119809-image.png


Any help would be appreciated .
Thanks


sql-server-generalazure-virtual-machinesazure-virtual-networkazure-virtual-machines-networking
image.png (11.4 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Criszhan-msft avatar image
0 Votes"
Criszhan-msft answered OuryBa-MSFT commented

Hi,

Please try to refer to this official document to check if there is anything you haven't noticed.

Connect to a SQL Server virtual machine on Azure


If this VM is not a SQL Server virtual machine, but a Windows VM with SQL Server manually installed,you may also need to allow connections to ports that SQL Server is listening on from the Azure portal.

SQL SERVER – FIX: Cannot Connect to SQL in Azure Virtual Machine From Laptop


· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @anthonyclarke-5616 Did you had the chance to check the answers provided above helped resolve your issue. ? If yes, could you please mark as accepted answer. Otherwise let us know how we can assist you better.

Regards,
Oury

0 Votes 0 ·

Hi @anthonyclarke-5616 Did you had the chance to check the answers provided above helped resolve your issue. ? If yes, could you please mark as accepted answer. Otherwise let us know how we can assist you better.

Regards,
Oury

0 Votes 0 ·
OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered ErlandSommarskog commented

... and that SQL Server is configured to allow remote connections.

And, are remote connections allowed? E.g. SQL Server Express don't allow remote connections by default.



· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

119810-image.png




it is on i think

0 Votes 0 ·
image.png (298.6 KiB)

You are looking in the wrong place. The "remote" connection you see in that screenshot is a legacy thing that should not be displayed in my opinion. You need to look in SQL Server Configuration Manager, SQL Server Network Configuration.

0 Votes 0 ·