question

rswarnka avatar image
0 Votes"
rswarnka asked shivapatpi-MSFT answered

Unable to connect to Azure SQL database from SSMS

Hi,

I followed this blog to create SQL Virtual Machine.

I am able to connect to the default DB within the VM itself, but Not able to connect through my ocal workstation(Laptop).



TITLE: Connect to Server
------------------------------

Cannot connect to 20.198.126.38.

------------------------------
ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-53-database-engine-error

------------------------------

The network path was not found

------------------------------
BUTTONS:

OK
------------------------------


144159-image.png


azure-sql-virtual-machines
image.png (95.7 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.

1 Answer

shivapatpi-MSFT avatar image
0 Votes"
shivapatpi-MSFT answered

Hello @rswarnka ,
You will have to add inbound security rule for that VM under Network Security Groups
TCP , Port : 1433

144263-image.png





Let me know if that helps. Please make sure to "Upvote & Accept the answer"

Regards,
Shiva.


image.png (122.6 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.