Installing the Enterprise Console version 4 database in a clustered SQL Server environment

For information on advanced installation, including placing the database on a separate computer from the console, see section 5 of the Advanced startup guide, and upgrading the database manually, in section 6.5 of the Advanced upgrade guide.

What to do

1. Create the domain group 'Sophos DB Admins'.
2. Decide which user domain account will be used by the Enterprise Console, version 4, server to access the database. If necessary, create a new account. Add the account (or appropriate group to which the account already belongs) to the domain group 'Sophos DB Admins'.
3. Logon on as administrator to the cluster node that is currently active.
4. Run the Enterprise Console, version 4, server installer, opt for Custom mode and select only the Database component. When prompted, select the SQL Server instance name and choose the option 'Populate database later'. Follow the installation wizard and complete the installation as described in the Advanced startup guide..
5. Make sure the account you are logged in has sysadmin privileges at the SQL Server instance where the database will be installed. Open a command prompt, and move to the folder %ProgramFiles%\Sophos\Enterprise Console\DB\
6. Run InstallDB.bat with the appropriate parameters:
   • The first parameter is the SQL Server instance name (format: Clustername\instanceName) in which the database will be created.
   • The second parameter is the name of domain in which the group 'Sophos DB Admins' has been created (see steps 2 and 3 above).
   • The third parameter is the database name of SOPHOS4. Do not change this name.
   Follow the progress of the file execution and make sure it completes successfully.
   
   Example:
   InstallDB Clustername\SQLADM Domain1
   (Installs to instance SQLADM on Clustername, where the group 'Sophos DB Admin' is in Domain1.)
   
7. Login as administrator on the server where the Enterprise Console server component will be installed.
8. Start the Enterprise Console version 4 server installer, opt in for custom installation, and select all server components except the database.
   • When prompted, specify the SQL server instance name where the database was installed during step 5.
   • When prompted, specify the account which the Enterprise Console server will use to access the database (see step 2).

   Complete the installation process as described in the Advanced startup guide.