Can not connect to sql server from Arc when firewalls are up

[RandallClark2]

So i can not connect to my sql server (2014) from Arc when my firewalls are up even when i have an rule allowing in and out bound connections on the following ports 1433 (default) and 50102 (the port in use by my server), Thoughts?

i also set it up so that it is based on the program sqlservr.exe and not the ports but that does help either.

thanks

[AsrujitSengupta]

SQL Server uses 1433 and 1434. Add those to Firewall Exceptions Inbound\Outbound rules and then check.