2. Go to the Windows Services app and verify the SQL Express (TREASOFT) or SQL Server is running along with SQL Server Browser. SQL Server Browser enables the Treasury Software to detect the database in the wizard dropdown seen below.

3. Install a local copy of the software on the server hosting the database to see if you can connect. If you are still not able to connect try typing in (local)\TREASOFT. Also, try the IP\TREASOFT.

4. Stop/restart the database through the Services panel. Then restart software and try to reconnect. You may need to use (local)\TREASOFT or IP\TREASOFT.

5. If possible, try rebooting the computer that is trying to connect to the database. After it has been rebooted, try reconnecting.

6. Check to see if it’s a firewall issue if you are unable to connect from a computer that is not hosting the SQL Express database. If possible, try turning off the Windows Firewall on the computer trying to connect to the database (Control Panel > View by Large Icons > Windows Firewall).

7. Confirm that ports 1433, 1434 - and possibly additional ports (see below) are open.

Open a Command window

From the prompt type
NETSTAT -a -n
and then hit enter.
Review the results - you should see 1433 and 1434 open at a minimum (TCP and UDP).

8. Need to create rules to get around the firewall?

http://treasurysoftware.com/support2-Configure-Windows-Firewall-Ports.html

9. Need to get around the Sample account? Click on File > New Account from the Welcome New Users screen

Existing installations:

1. Ask if any computer can connect. I would suggest confirming this by entering into the software from another machine and running any report.

2. For SQL Server installations check permissions -> http://www.treasurysoftware.com/Support/support2-Troubleshooting-SQL-Server.aspx

3. Go to the Services panel and verify the SQL Express (TREASOFT) or SQL Server is running along with SQL Server Browser. SQL Server Browser enables the Treasury Software to detect the database running in the wizard.

4. Stop/restart database. Then restart software and try to reconnect.

5. If no computers can connect, install a local copy of the software on the server hosting the database to see if you can connect. If you can connect locally and not from another computer then it’s a connectivity issue, probably a firewall issue.

6. If possible check to see if it’s a firewall issue by turning off Windows Firewall.

7. Confirm that ports 1433, 1434 - and possibly additional ports (see below) are open.
Open a command window and from the prompt type
NETSTAT -a -n
and then hit enter.
Review the results - you should see 1433 and 1434 open at a minimum (TCP and UDP).

8. Need to create rules to get around the firewall? http://treasurysoftware.com/support2-Configure-Windows-Firewall-Ports.html

Still not connecting?

1. Select Start, and in your list of programs, select SQL Server Configuration Manager. If you are unable to find it try the following:
Control Panel>Administrative Tools>Computer Management

2. Navigate to SQL Server Configuration Manager > SQL Server Network Configuration > Protocols for <machine instance>. If using the Treasury Software SQL Express database select the database with ‘TREASOFT’.

3. Double-click Named Pipes. The Named Pipes Properties screen appears.

4. From Enabled, select Yes. Then click OK.

5. Double-click TCP/IP. The TCP/IP Properties screen appears.

6. On the Protocol tab, ensure Yes is selected for Enabled. On the IP Addresses tab, ensure that Yes is selected for the appropriate IP Address. Also, ensure that the appropriate TCP Port is indicated.

Scroll down and enable for IP4 and IP6 Click OK.

7. Go into the Services Panel and restart the database (run > services.msc).

Restart the database.