Error: Error 26 unable to connect to database

Solution

  1. Check that the Settings file was installed with the Client - go to the 4Matrix folder and check it exists, and that it's larger than 0kb. Go to step 5 if it's not there or shows as 0kb.
  2. Open the 4Matrix Network Manager on the server and go to Connections. Check that if the Firewall is shown as enabled, that you have made incoming exceptions for both of the paths shown on this panel.
  3. If the Firewall is off, or the exceptions have been made, check that the client can ping the server.
  4. Make sure that the SQL Browser service is started.
  5. In the 4Matrix Network Manager, click 'Re Copy Files'. Go to the client files folder and copy the Settings file. Add it to the 4Matrix folder on the client, overwriting the existing version if there is one.
  6. The SQL Server name is limited to 15 characters. If the server name is longer than this then you should replace it with the IP address using the 4Matrix Network Manager. Work through the wizard, replace the name, and then click Re-Copy Files. Replace the Settings file on the client.
  7. If it still shows the error, contact us for further help.
 
Was this article helpful? yes / no
 

 
Powered by Help Desk Software HESK, brought to you by SysAid