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

   



3. Select 'Advanced Settings'.

   



4. Select 'Inbound Rules and then New Rule'.

   



5. Select 'Program' and then select 'Browse'.

   



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.

   



7. Click 'Next'.

   



8. Select 'Allow the connection' and then 'Next'.

   



9. Choose your domain and then select 'Next.'

   



10. Give your new rule a name and click 'Finish'.

    



11. Verify the rule you just named is enabled.

    



12. Right click on your rule and select 'Properties' then the 'Programs and services' tab.

    



13. Click on 'Settings'.

    



14. Select 'Apply' to services only and then select 'OK'.

    



15. Lastly select 'Apply'.

    



16. Congratulations, you are done.