PhraseExpress has no way to bypass such bottleneck. If experience a slower load time over a VPN internet connection than with a local SQL server network connection, this would solely be caused by the VPN connection. Those will be loaded and processed at startup and may slow down the loading time. Check your phrase library for dynamically linked files.This will reduce the number of phrases to be loaded. Organize phrases in work groups such as Sales, Support, Accounting and restrict access to such phrase folders accordingly. In many cases, not everybody needs to load all phrases of all users. The PhraseExpress only loads the phrases, the user has read permissions for.Otherwise the phrase contents of all phrases would be downloaded onto the PhraseExpress client which can take a lot of time with larger databases. Disable pre-loading of all phrase contents in PhraseExpress settings.To maximize SQL database loading performance on PhraseExpress startup: If the client cannot find the SQL server by its name, try connecting it by its IP address. Any Windows computer made in the last 10 years should be able to run modern applications like PhraseExpress: Windows 10/11.Make sure that you can ping the SQL server computer from the workstation computers ( instructions).If missing, repeat the PhraseExpress client installation and make sure to have the option " SQL server support" enabled.Īlternatively, ODBC Driver 17 is supported. 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:.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.All clients must have the same version number. Older clients such as v15 cannot connect to databases created with v16. The main version number must match the PhraseExpress SQL Client Manager version. Make sure to run the latest PhraseExpress Client software version on all computers. The SQL server service must be restarted before any configuration change takes effect.Ĭonsult your IT administrator before you make any changes to the SQL server configuration. If using "Windows authentication", make sure to add the desired users in the PhraseExpress SQL Client Manager.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":.This can be configured in the "Microsoft SQL Server Management Studio" with the SQL query GRANT VIEW ANY DEFINITION TO All users need "View Definition" rights to the Master SQL database.If the server service is not running, right-click and select "Start" from the popup menu. On the SQL Server computer, run the "Microsoft SQL Server Configuration Manager" to verify, that the SQL server service is running:.Carefully review and double-check the essentially important Microsoft SQL Server configuration steps in chapter Installation.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |