If PhraseExpress Mac clients are used, the authentication mode must be set to ' Mixed Mode (SQL server and Windows authentication)'.If ' Windows authentication' is used, add users, that shall be allowed to connect to the SQL server in the 'PhraseExpress SQL Client Manager' under Tab ' Clients'.If you change the TCP port in the SQL server configuration, you must update the firewall rule accordingly. On the server computer, you must configure the firewall to allow incoming connections on the configured TCP port:.Please find more information in the Microsoft SQL Configuration Manager documentation.

IMPORTANT: The default 0 ('zero') does not disable 'TCP Dynamic ports'. the standard SQL server port 1433 for all IP entries and disable ' TCP Dynamic ports' by blanking its input field(!): In the 'Microsoft SQL Configuration Manager', select ' SQL Server Network Configuration', right-click the TCP/IP protocol item, select ' Properties', switch to tab ' IP addresses' and scroll down to section ' IPAll': Configure a TCP port, e.g. Microsoft SQL Server should be configured to use a static TCP port (required if using PhraseExpress on a Mac).If any TCP protocol is disabled, right-click the entry and select 'Enable' from the popup menu. In the same 'Microsoft SQL Configuration Manager', make sure that the TCP protocol is enabled:.If the 'SQL Server Browser' service is stopped, right-click the entry and enable it. If you want the PhraseExpress SQL Client Manager to find the SQL server automatically, change the ' SQL Server Browser' service default setting from 'Disabled' to 'Automatic' in the 'Microsoft SQL Configuration Manager':.If you want to use an existing Microsoft SQL Server for PhraseExpress, you may need to configure it: If the SQL Server is not installed despite selecting the option, make sure that the '.NET Framework' is installed in the Windows program 'Windows Features'. If the PhraseExpress SQL Client Manager is kept running, the clients should auto-connect to the SQL server. Install and run the regular PhraseExpress clients on all workstation computers. Without license keys, you can evaluate PhraseExpress with all features. If you have purchased PhraseExpress, register the license keys.The initial installation wizard guides you through the creation of the phrase and license database. Launch the PhraseExpress SQL Client Manager.The installer offers you to install a pre-configured Microsoft SQL Server in the free Express Edition which is 'ready-to-use' and suitable for most use cases.We recommend to install it on the server computer running the SQL server for a direct and stable connection. Download and install the 'PhraseExpress SQL Client Manager'.Video instructions To install the PhraseExpress SQL Client Manager:

We recommend to watch the step-by-step installation video instructions:

Mac sql server client free