Configure Windows Firewall ports on the computer hosting the database to allow Treasury Software access
If you are having issues connecting to the SQL Express database and are using the Microsoft firewall then please try the following steps on the computer hosting the database. If you need to call us please make sure you have installed the software on the client along with installing the SQL Express database on the server or workstation.
1. Click on the Start button and then select 'Control Panel'.
2. Next select 'Windows Firewall'.
![Windows Firewall](images4/Control_Panel_Icon.gif)
3. Select 'Advanced Settings'.
![Windows Firewall Advance](images4/Windows_Firewall_Advance.gif)
4. Select 'Inbound Rules and then New Rule'.
![Windows Firewall Inbound Rules](images4/Windows_Firewal_Inbound_Rules.gif)
5. Select 'Program' and then select 'Browse'.
![Windows Firewall Program](images4/Windows_Firewall_Program.gif)
6. Navigate to the following location and then select 'sqlbrowser'. Once selected click 'Open'. Note: If you are unable to find sqlbrowser in this location try looking for it under the Program Files (x86) folder.
![Windows Firewall SQL Browser](images4/Windows_Firewall_SQL_Browser.gif)
7. Click 'Next'.
8. Select 'Allow the connection' and then 'Next'.
![Windows Firewall Connection](images4/Windows_Firewall_Connection.gif)
9. Choose your domain and then select 'Next.'
![Windows Firewall Rule](images4/Windows_Firewall_Rule.gif)
10. Give your new rule a name and click 'Finish'.
![Windows Firewall Inbound Rule Name.](images4/Windows_Firewall_Inbound_Rule_Name.gif)
11. Verify the rule you just named is enabled.
![Verify Rule Enabled](images4/Verify_Rule_Enabled.gif)
12. Right click on your rule and select 'Properties' then the 'Programs and services' tab.
![Program and Services](images4/Program_Services.gif)
13 Click on 'Settings'.
![SQL Connection Properties Settings](images4/SQL_Connection_Properties_Settingst.gif)
14. Select 'Apply' to services only and then select 'OK'.
![SQL Connection Properties](images4/SQL_Connection_Properties.gif)
15. Lastly select 'Apply'.
![Apply Windows Firewall Rule](images4/Apply_Windows_Firewall_Service.gif)
16. Congratulations as you are now done!
|