Unable to connect to Azure SQL database from SSMS

Question

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://learn.microsoft.com/sql/relational-databases/errors-events/mssqlserver-53-database-engine-error  
     
     
   \------------------------------  
     
     
   The network path was not found  
     
     
   \------------------------------  
     
   BUTTONS:  
     
   OK  
     
   \------------------------------  

Answer 1

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

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

Regards,
Shiva.