After checking the Services panel and the Firewall, if you are still unable to connect, you may need to enable TCP/IP:
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
If you are still unable to start it, you may need to enable it. See our Enabling SQL Configuration Manager.
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.
You should be able to connect.
If you still cannot connect, please install an updated version of SQL Server Native Client
or SQL Server Management Studio.
Using a non-standard port?
1. On the server hosting the database. 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. Expand SQL Server Network Configuration > select Protocols for your database > right click on TCP/IP > select properties.
3. Select IP Addresses tab > scroll down to IPALL > copy the port number for TCP Dynamic Ports.
4. Next go into Treasury Software > click on the Settings tab > Migrate to SQL Express, SQL Server > type in your server name if it does not appear in the dropdown > add a comma and the port number.
Note. There is not a space between the comma and the port number.
