The reason you are reading this page is because you are having issues connecting the Treasury Software to either the Treasury Software SQL Express database or to your own SQL Server.
- Please verify that the Treasury Software SQL Express database (Treasoft) or your existing SQL Server is running in the Services panel on the server/computer hosting the database. To access the Services Panel, right click on the Windows Logo in the left corner of your screen and select ‘Search’. Now click on Services.
- Scroll down till to verify the SQL Express (Treasoft) or your own SQL Server database is running. If the database is not running, you will have the option to ‘Start’ it in the top left or you can right click on it and select Start.
- In addition, make sure the SQL Browser is running. If the SQL Browser is not running, you will have the option to ‘Start’ it in the top left or you can right click on it and select Start.
- If you had to start either the SQL Browser or database, please go back into the Treasury Software and attempt to make the connection by clicking on the Settings tab > Migrate to SQL Express, SQL Server.
- If you are still unable to make the connection, check to see if the Windows Firewall is active. Right click on the Windows Logo in the lower left and select Search.
- Click on Monitoring and check the status of the firewall. If the firewall is not active, skip down to step 19.
- If active, now you are going to create an inbound rule for the SQL database and for SQL Browser. First, click on Inbound Rules at the top left and then New Rule at the top right.
- Select Program and then Next.
- First we are going to make a rule for the SQL Browser. Select the option for this program path and then navigate to the following location to select sqlbrowser.exe. Note, your shared directory will vary on the version of SQL you are running. Click Next to advance to the next screen.
C:\Program Files (x86)\Microsoft SQL Server\xxx\Shared
- Select Allow the connection and then Next.
- Leave all of these checked and click Next.
- Provide a name for the rule and then click Finish.
- Now right click on the rule you just created and select Properties.
- Select the Programs and Services tab and then Settings under the Services section.
- Select Apply to services only and then OK.
- Lastly, click Apply.
- Now you are going to need to repeat steps 6 – 14. However, instead of pointing to the SQL Browser, you are now going to point to the SQL database. The following example shows you where the Treasury Software database is located. Note your MSSQL directory will vary on the version of SQL you are running.
C:\Program Files (x86)\Microsoft SQL Server\MSSQL11.TREASOFT\MSSQL\Binn\ sqlservr.exe
- Once you have created both the SQL Browser and SQL database rule, please enter back into the software to try and make the connection to the database (Settings tab > Migrate to SQL Express, SQL Server).
- If you are still unable to make the connection, try enabling TCP/IP and Pipes on the server. Please see the following link.