20 years PhraseExpress - Major new version 16.1 out now!

Troubleshooting

PhraseExpress should work fine in standard configurations if you followed the installation instructions.

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

Step-by-Step video instructions

If SQL server administration appears too complex, please consider using a network drive or cloud synchronization to share phrases which is easy to setup.

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" to 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":



  • If using "Windows authentication", make sure to add the desired users in the PhraseExpress SQL Client Manager.

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.

Database Creation Troubleshooting

In case of database creation problems:
  1. Exit "PhraseExpress SQL Client Manager".
  2. Use the "MS SQL Management Studio" to delete the database(s) that could not be created ("pexphrases.mdf" or "pexlicense.mdf") including associated file(s) (e.g. "pexlicense_log.ldf").
  3. Verify in "MS SQL Management Studio" that the SQL Server has write permissions for the database storage location.
  4. If using Windows authentication, make sure in "MS SQL Management Studio" that you have write and create permissions to create SQL databases.
  5. If "PhraseExpress SQL Client Manager" is not running on the same computer as the SQL Server, try running it on the same computer.

Client Connection 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.

    Alternatively, ODBC Driver 17 is supported.
  • Make sure that you can ping the SQL server computer from the workstation computers (instructions).
  • Each computer must have a unique name.
  • If the client cannot find the SQL server by its name, try connecting it by its IP address.

Database Connection Troubleshooting

In case of database connection problems, create following new query in "MS SQL Management Studio":

USE master;

CREATE LOGIN [DOMAIN\USERNAME] FROM WINDOWS; GRANT VIEW ANY DEFINITION TO [DOMAIN\USERNAME];

USE pexlicense;

CREATE USER [DOMAIN\USERNAME] FOR LOGIN [DOMAIN\USERNAME]; ALTER ROLE db_datareader ADD MEMBER [DOMAIN\USERNAME]; ALTER ROLE db_datawriter ADD MEMBER [DOMAIN\USERNAME]; GRANT EXECUTE TO [DOMAIN\USERNAME];

USE pexphrases;

CREATE USER [DOMAIN\USERNAME] FOR LOGIN [DOMAIN\USERNAME]; ALTER ROLE db_datareader ADD MEMBER [DOMAIN\USERNAME]; ALTER ROLE db_datawriter ADD MEMBER [DOMAIN\USERNAME]; GRANT EXECUTE TO [DOMAIN\USERNAME]; GRANT ALTER ON levels TO [DOMAIN\USERNAME];

Replace "DOMAIN\USERNAME" with your actual account information.

This information is reserved for users with sufficient SQL server management skills. Know what you are doing.

Table of Contents


Table of Contents