SQL Server Remote Connections

Question

I've been through the settings a hundred times and to no avail, I can not get remotely connected to a SQL Server on my network. I have two SQL Servers on different machines. I can connect to one, but not the other. As far as I can tell, all the server properties and server configurations are identical.

I have all firewalls turned off completely. I've even googled for how to do this because at this point I feel like a completely lost noob. I can ping and communicate with the remote machine. Just can't see the SQL Server.

https://blogs.msdn.microsoft.com/walzenbach/2010/04/14/how-to-enable-remote-connections-in-sql-server-2008/

I've done all that. Yes, I'm using 2008 R2, as that's the supported server by the software manufacturer that I'm exchanging data with.

What could I possibly be missing?

Answer 1

I was able to see and connect after adding Outbound UDP 1434 to my exceptions.

Answer 2

My first step is to check is the TCP/IP is enabled for the instance of the SQL server you want to connect too.

The next thing to try is telnet to the server: telnet SERVER.IP.ADDRESS 1433

This article is helpful

More info here