This documentation refers to PhraseExpress v16 beta. The documentation for current v15 is available here.

Troubleshooting

PhraseExpress should work fine in standard configurations if you followed the installation instructions. Please review the instructions carefully step-by-step and do not skip any step.

Following trouble-shooting tips should be able to help you solving connection issues:

Step-by-Step video instructions

SQL Server Troubleshooting

  • Carefully review and double-check the essentially important Microsoft SQL Server configuration steps in chapter Installation.
  • On the SQL Server computer, run the "Microsoft SQL Server Configuration Manager" and verify that the SQL server service is running:



    If the server service is not running, right-click and select "Start" from the popup menu.
  • All users need "View Definition" rights to the Master SQL database. This can be configured in the "Microsoft SQL Server Management Studio" with the SQL query GRANT VIEW ANY DEFINITION TO [USERNAME OR GROUP]

If using PhraseExpress for Mac, verify in the "Microsoft SQL Server Management Studio" (does not come with SQL server installation by default; must be installed separately), that Authentication mode is set to "SQL server and Windows authentication (mixed mode)" in section "SQL server properties":



The SQL server service must be restarted before any configuration change takes effect.

Consult your IT administrator before you make any changes to the SQL server configuration.

Client Troubleshooting

  • Make sure to run the latest PhraseExpress Client software version on all computers. The main version number must match the PhraseExpress SQL Client Manager version. Older clients such as v15 cannot connect to databases created with v16. All clients must have the same version number.
  • To allow the PhraseExpress clients finding the SQL server automatically, make sure that the PhraseExpress SQL Client Manager is running and that the "Auto-find SQL Server" feature is enabled in PhraseExpress settings.
  • On all Windows computers, run the utility "ODBC Data Source Administrator" (included in Windows) to check if the required "Microsoft SQL Server - Native Client" is installed:



    If missing, repeat the PhraseExpress client installation and make sure to have the option "SQL server support" enabled.
  • Make sure that you can ping the SQL server computer from the workstation computers (instructions).

Table of Contents


Table of Contents