70-462 Connectivity from SQL-A to SQL-CORE RRS feed

  • Question

  • 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.

    • Edited by Casey.B Tuesday, March 28, 2017 1:41 PM spelling
    Tuesday, March 28, 2017 1:41 PM