External connection to windows server VM

[abilio_iunes]

Hello, I created a Windows Server VM and installed SQL Server, setted up my database and now a need to connect my company's computer to this database but I can't. I did a ping to the external IP and is ok, but when I try to connect thru SQL Client, It's unsuccessfully. How can I connect my company computers to my google cloud VM?

[ms4446]

Here are the steps on how to connect company computers to Google Cloud VM:

1. Check the firewall rules on both the company computers and the Google Cloud VM. Make sure that the firewall rules allow traffic to the SQL Server ports. The default port for SQL Server is TCP 1433,but you may need to use a different port if you have changed the default port.
2. Make sure that the Google Cloud VM has a public IP address. You can allocate a public IP address to the VM in the Google Cloud console.
3. Check the SQL Server Configuration Manager to ensure that the SQL Server instance allows remote connections.
4. Check the SQL Server authentication mode. If it is set to "Windows Authentication",external computers might face issues unless they are part of the same domain. "SQL Server and Windows Authentication mode" is more flexible for such scenarios.
5. Try connecting to the VM from one of the company computers using a SQL client. You can use the SQL Server Management Studio or any other SQL client that supports SQL Server connections.

If you are still unable to connect to the VM from the company computers, you can contact Google Cloud support or Microsoft support for assistance.

Additional troubleshooting tips:

• Make sure that the VM and SQL Server are running.
• Check the error messages received during connection attempts. These messages can provide valuable clues about the nature of the problem.
• Restart the SQL Server service on the VM.
• Try connecting to the VM from a different computer.