1. Installation and Configuration

  • Note: ORC computers are SMRU-ORC-MKT, SMRU-ORC-MLA, SMRU-ORC-WPA, SMRU-ORC-MSL.

2. Configuration

  • Add Data-DbDev AD group for DM in SQL Server.

  • Add Data-DbDev AD group to the Remote Desktop Users group.

    • Log on as Administrator.

    • Start Local Users and Groups (lusrmgr.msc).

    • Right-click Remote Desktop Users and select Properties.

    • Click Add.

    • Type Data-DbDev AD group in the Enter the object names to select field and click Check Names.

    • Type your domain user name and password.

    • Click OK.

    • Click OK.

    • Click Apply.

    • Click OK.

    • Close Local Users and Groups.

2.1. SQL Server Configuration Manager

2.2. Windows Firewall

  • Start Windows Firewall.

  • Select Advanced settings.

  • Select Inbound Rules.

  • Select Action > New Rule.

  • Choose Port.

  • Click Next.

  • Choose TCP.

  • Choose Specific local ports.

Specific local ports:           1433

  • Click Next.

  • Choose Allow the connection.

  • Click Next.

  • Check Domain.

  • Check Private.

  • Check Public.

  • Click Next.

Name:                           SQL-TCP-Port 1433
Description:

  • Click Finish.

  • Right-click SQL-TCP-Port 1433 in Inbound Rules.

  • Select Properties.

  • Click Scope tab in SQL-TCP-Port 1433 Properties window.

  • Choose Any IP address under Local IP address.

  • Choose These IP addresses: under Remote IP address.

  • Click Add under Remote IP address.

  • Choose Predefined set of computers: in IP Address window.

  • Select Local subnet in Predefined set of computers dropdown list.

  • Click OK.

  • Click Add under Remote IP address.

  • Choose This IP address or subnet.

  • Type 10.10.1.0/24 in This IP address or subnet: field.

  • Click OK.

  • Click Apply.

  • Click OK.

  • Close Windows Firewall.