MS SQL CLIENT FOR WINDOWS FOR MAC
MS SQL CLIENT FOR WINDOWS INSTALL
MS SQL CLIENT FOR WINDOWS PASSWORD
MS SQL CLIENT FOR WINDOWS FREE

If UDP broadcasts are blocked due to network restrictions: No data is transmitted outside the local network and/or internet. The communication through UDP is limited to the local network. The PhraseExpress clients call the SQL Client Manager through UDP port 1047 in the local (only!) network and the PhraseExpress SQL Client Manager replies with SQL server connection information through UDP 1036 and the clients automatically switch from the local phrase file to the SQL database. To allow the clients to find the SQL server automatically, enable option ' Auto-find SQL Server' in the PhraseExpress client Settings В» Network on all computers.

Make sure to keep the option 'MS SQL Server Support' enabled which adds the required Microsoft Native SQL Client to the installation.

MS SQL CLIENT FOR WINDOWS INSTALL

Install the PhraseExpress client ( download) on all workstations.

Make sure that the PhraseExpress SQL Client Manager is running in the background which enables the PhraseExpress clients to find the SQL server automatically.

The default 0 ('zero') does not disable it. IMPORTANT: For unknown reasons, Microsoft decided, that the option is disabled if you make it blank.

Under ' SQL Server Network Connection', disable ' TCP Dynamic ports' by blanking it(!):.

1433 for all IP entries ( see Microsoft SQL Configuration Manager documentation).

Microsoft SQL Server must be configured to use a static(!) TCP port 1433: In Microsoft SQL Configuration Manager, select ' SQL Server Network Configuration', right-click the TCP/IP protocol item, select ' Properties' and switch to tab ' IP addresses': Configure configure a TCP port, e.g.

Enable the TCP/IP protocol in the 'Microsoft SQL Configuration Manager':.

MS SQL CLIENT FOR WINDOWS FREE

This can be configured with the 'Microsoft SQL Server Management Studio' ( free download) under the ' SQL server properties' ( instructions):

MS SQL CLIENT FOR WINDOWS FOR MAC

PhraseExpress for Mac clients require the authentication mode ' Mixed Mode (SQL server and Windows authentication)'.

If you don't know the SQL server instance name and 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'.

This is included in the installation files for PhraseExpress SQL Client Manager and Client.

Make sure that the 'Microsoft SQL Server - Native Client' is installed on all Windows PCs and the computer running the PhraseExpress SQL Client Manager.

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.

MS SQL CLIENT FOR WINDOWS PASSWORD

You may also need to define a password for the SQL administrator account 'sa' and activate the account ( instructions). If ' Mixed Mode (SQL server and Windows authentication)' is selected, run the 'Microsoft SQL Server Management Studio' and add users, that shall be allowed to connect to the SQL server.To maintain control of the IP address used by the SQL server (required if using Mac clients), consider disabling the 'Dynamic port' feature by removing the default 0 ('zero') to a blank value ( Microsoft instructions). IMPORTANT: The default port can differ - even if a specific port is configured - if option ' Dynamic port' is enabled. On the server computer, configure the firewall to allow incoming connections on the configured TCP port used by the SQL server (default port is TCP 1433).If you want to use an existing Microsoft SQL Server for PhraseExpress, it is mandatory to configure it.

Ms sql client for windows