Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Add the following Firewall Rule
    1. Allowed IP: 74.208.175.239
    2. Protocol: TCP
    3. Port: 1433
    Open
  2. Make the following changes in SQL Server Configuration Manager
    1. Enable enable TCP/IP in SQL Server Network Configuration section.
    2. Image Added
  3. Then right click on TCP/IP and select Properties.
    1. Switch to the IP Addresses tab and scroll to the bottom and make the following changes.
    2. TCP Dynamic Ports: this should be blank
    3. TCP Port: 1433
    4. Image Added



How to find SQL Server Configuration Manager

  1. You can find the SQL Server Configuration Manager in the C:\Windows\SysWOW64 directory folder.
  2. You will see Double click on one of the following files in that folder depending on the version of SQL Server you are running.
    1. SQLServerManager11.msc (SQL Server 2012)
    2. SQLServerManager12.msc (SQL Server 2014)
    3. SQLServerManager13.msc (SQL Server 2016)
    4. SQLServerManager14.msc (SQL Server 2017)
    5. SQLServerManager15.msc (SQL Server 2019)Enable enable TCP/IP in SQL Server Configuration Manager
  3. Double click the file matching the version of SQL Server you are running the i21 database on.