CODEWITHSUNDEEP
sql-servervirtual-machinessmsconnexionremote-connection
ikram zouaoui
ikram zouaoui

Reputation: 33

Connect to SQL Server running on a distant VM from my desktop

I have created an SQL Server on a VM. When I try to connect to my SQL Server on the VM, everything is fine but when I try to connect to it from my desktop via SSMS I have this problem :

A network-related or instance-specific error occurred while establishing a connection to SQL Server. Verify that the instance name is correct and that SQL Server is configured to allow remote connections

I have :
Enabled SQL Server authentication mode
Created a SQL login
Enabled TCP/IP protocol
Enabled firewall rule for the SQL Server port

but still getting the same error.

Upvotes: 0

Views: 332

Answers (0)

Related Questions