After getting through the firewall using the instructions on the website, you should be able to see the database in the dropdown but may still not be able to connect. It is necessary to enable TCP/IP on the server, which resolves the connection issue.
On the server, select Start and in your list of programs, select SQL Server Configuration Manager. Note, if you are not able to find SQL Server Network Configuration then skip down to the bottom of this page to see how to enable it. Once enable you can continue with the following instructions.
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’.
Double-click Named Pipes. The Named Pipes Properties screen appears. From Enabled, select Yes. Then click OK.
Double-click TCP/IP. The TCP/IP Properties screen appears.
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.
Go into the Services Panel and restart the database (run > services.msc).
Restart the database.
How to enable SQL Server Configuration Manager
1. First step is to right click on the Windows logo and select Run.
2. Next type mmc.exe.
3. Next, select File > Add Remove Snap-in.
4. Lastly, select SQL Server Network Configuration > click on the Add button > Ok. Now you can return to the instructions at the top of the page.