I have setup virtual machines running Win Server 2008 R2 Standard in Virtualbox and I have can connect some in one direction but not the other. I am at a bit of a loss as to how to troubleshoot.
I have the machines DC, SQL-A, SQL-B and SQL-CORE on the Contoso domain with a GPO and an Inbound Program Firewall Rule from the end of chapter 1.
The result is I can connect to databases in the following directions:
SQL-A -> SQL-B via SSMS or sqlcmd
SQL-B -> SQL-A via SSMS or sqlcmd
SQL-CORE -> SQL-A via sqlcmd
But I cannot connect to the database on SQL-CORE from SQL-A using either program.
It was not instructed, but I did note I could only connect between SQL-A and SQL-B after I used SQL Server Config Manager to use fixed port 1433. But I did not do so for SQL-CORE as I am not sure how from the command line.