Synergy uses Microsoft SQL and is shipped in two variants: W700A and W700B.

•If the target server does NOT have an existing Microsoft SQL Server instance and you do not wish to use/have an appropriate Microsoft SQL server available on the LAN, then Synergy W700A / W706A is required.

•W700A is distributed with a SQL Express 2014 (with tools) Bootstrapper, which will install SQL and Microsoft SQL Server Management Studio on the Synergy Server.

•During W700A installation, the System Administrator password is set to P3nd13H0us3. This is done solely to provide a password without User interaction; Synergy does not use the System Administrator account.

•If there is an existing Microsoft SQL Server, on the target server or LAN, that you wish to use for Synergy, then Synergy W700B / W706B is required.

•W700B is distributed without SQL and is intended for installation where the customer wishes to use an existing SQL instance.

 

Existing Microsoft SQL Instance

If there is an existing Microsoft SQL Server on the target Server or LAN that you wish to use for Synergy, then the following conditions must be met:

•Synergy W700B must be used.

•SQL Instance must be set to SQL login and Windows Authentication mode.

•The installing Windows login should be a member of the sys admin role and must have full Administrative privileges for the SQL Instance.

•SQL Server Browser Service must be running during Synergy install and SynergyConfig utility operation.

•SQL Server Management Studio (SSMS) must be installed.

 

 

Restoring an SQL Database

Restoring an SQL database requires all other connections to the database to be closed. If doing this from SSMS or similar, run the MS Services MMC (Microsoft Management Console) and make sure Apache 2.4 and all the Synergy Services are stopped first; also, close any open SSMS edit windows connected to the database being restored.