New SQL

The server service requires an SQL database to store all of it's information.
This can either be an SQL Express instance for small sites and for testing or a full Standard or Enterprise installation.
If you use an Express instance for testing this can later be upgraded to a full Standard or Enterprise edition.
SQL Express downloads as a single executable file. This is the file that the Installation Assistant will need to install SQL.
Using a Standard or Enterprise edition comes as an ISO image or on a DVD. The executable that the Installation Assistant uses is the setup.exe on the root of the disc.

You can set a custom instance name if required for any reason but otherwise the default BCXSQL is fine.

Existing SQL

If you choose to use an existing SQL instance we recommend using a dedicated instance, and there are some specific requirements needed for the server service to run.
The SQL instance must have the Domain Admins group added to the security section of SQL server and database security mapping for the SYSTEM account.
This can be done by using the SQL Server Management Studio, expanding the Security section, right clicking Logins, and clicking New Login...

With the New Login box open, click Search.

Click Object Types... and click the Groups check box, press ok. Click Locations... and choose Entire Directory and press OK.
Type Domain Admins in the bottom box and click Check Names. This should underline Domain Admins. Press OK.

Click User Mapping and put a tick in the tickbox next to bcxdb database.
In the bottom section of the window, tick the boxes for the options db_datareader and db_datawriter. Press OK.

Back in SQL Management, in the list of Logins, find the user NT AUTHORITY\SYSTEM. Right click and go to properties.

Go to User Mapping and in the bottom section of the window, tick the boxes for the options db_backupoperator, db_datareader, db_datawriter and db_ddladmin.
Press OK.

This is to allow all Domain Admin users to access the manager, and the server service and backup utility to access the SQL database.

The username and password given during the installation must have access to be able to create the BCX database and restore the data from a file.

Back