Create Windows Firewall Exception
- Access the Microsoft SQL Server Configuration Manager. For steps to do this see the Accessing SQL Server Configuration Manager article.
- Yearli 2018 - 2021: Microsoft SQL Server Configuration Manager 2014 or 2015
- Yearli 2022 - Present: Microsoft SQL Server Configuration Manager 2019
- On the left, expand the SQL Server Network Configuration by clicking the + sign next to it.
- Choose Protocols for GREATLAND, or GREATLANDYD*.
- Yearli 2018 - 2021: GREATLAND
- Yearli 2022 - Present: GREATLANDYD
- Right click on TCP/IP and select Properties.
- Choose the IP Addresses tab.
- Scroll to the bottom.
- Write down the TCP Dynamic Ports number under the IPAll heading.
- Close the SQL Server Configuration Manager.
- Access the Windows Run window by pressing the Windows key and R key on the keyboard.
- Type "firewall.cpl" without the quotes in the Open field.
- Click OK.
- Click Advanced settings.
- Choose Inbound Rules.
- Choose New Rule...
- Choose Port.
- Click Next.
- Choose TCP and Specific local ports.
- In the field next to Specific local ports, enter the TCP Dynamic Ports number from step 7.
- Click Next.
- Choose Allow the connection.
- Click Next.
- Check Domain, Private, and Public.
- Click Next.
- Name the rule and add a description if you would like.
- Click Finish.
*The SQL Server instance will differ depending on the version of the program. The SQL servers associated with each version of the program are:
- Winfiler 2012 - 2013: WF_SS8E
- WinFiler Plus 2013 - 2014: WFP_SS8E
- Yearli 2014: WFP_SS8E
- Yearli 2015: WFP_SS8E or YD2015_SS8E
- Yearli 2016: WFP_SS8E or YD2015_SS8E
- Yearli 2017: WFP_SS8E or YD2015_SS8E
- Yearli 2018 - 2021: GREATLAND
- Yearli 2022 - Present: GREATLANDYD