Connecting to SQL Server in VM Instance using SSMS

[lordhood]

Hello Everyone,

I have a VM instance running Ubuntu 20.04 in Compute engine. My ultimate goal is to host a .Net/Angular/MS-SQL app on this server. I installed MS-SQL 2019 Developer Edition on this Ubuntu, the server is running, I have added 1433 port in firewall, I have added  a line in  /var/opt/mssql/mssql-conf for 1433 port.

I can ping the VM from my windows machine, but when I launch SSMS in Windows machine to connect, it is not able to connect to the server :  

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

Cannot connect to <hidden IP address>.

------------------------------
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-err...

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

The network path was not found

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

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

Any help on what can be done?

[ms4446]

Hello,

You might need to enable TCP/IP for protocol on your managed instance of SQL Server. Please refer to the following link how to enable TCP/IP via PowerShell

https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/enable-or-disable-a-server-n...