How to configure Browser Security Plus to make it use MS SQL Server as the database?

Browser Security Plus extends support for using MS SQL database for storing the configuration and data. This document will explain the steps,

To configure MS SQL as the back-end database for Browser Security Plus Server.
To set up a fresh MS SQL database or migrate data from an existing database to new MS SQL database.

Hardware Requirements for SQL Server

The hardware requirements for SQL server include the following:

No. of Computers/Devices Managed	Processor Information	RAM Size	Hard Disk Space
1 to 5000	Intel Core i7 (6 core/12 thread) 3.2 GHz. 12 MB cache	8 GB	200 GB*
5001 to 10000	Intel Xeon E5 (8 core/16 thread) 2.6 GHz. 20 MB cache	16 GB	250 GB*
10001 to 15000	Intel Xeon E5 (12 core/24 thread) 2.7 GHz. 30 MB cache	32 GB	500 GB*
15001 to 20000	Intel Xeon E5 (14 core/28 thread) 2.7 GHz. 30 MB cache	64 GB	500 GB*

* May increase dynamically according to the frequency of scanning.

Note :

Browser Security Plus Supports MS SQL 2008 or later versions.
If you are using "Failover Server" contact our support team for migration assistance.
This document is applicable for migrating Browser Security Plus from MYSQL to MSSQL, PGSQL to MSSQL, one MSSQL server to another.

Change the Database Server to MS SQL

The following steps will explain you, to backup the data from the old server, change the database server and restore the data in the MS SQL database.

Click here and know the steps to configure SQL server (Proceed with step 2 if the SQL server is already configured).
Perform the steps below from the computer where MS SQL Server is installed,
1. Choose Start --> Run and type services.msc.
2. Ensure that "SQL Browser" service has been started. If not, start the service.
3. Open the SQL Server Configuration Manager from the Start menu
4. Expand SQL Server Configuration Manager (Local) and navigate to SQL Server Network Configuration.
5. Choose the Instance on which you wish to run the database and check if TCP/IP ports are enabled. If not, right-click on TCP/IP and enable it.
6. You should restart the SQL Service after you enable TCP/IP. Select SQL Server Services from the left pane, right-click the instance and choose Restart.
  Note: Ensure that the you configure Windows firewall to allow access to SQL server. Refer this document for more information.
Migrating the database to SQL server
From the computer where Browser Security Plus Server is installed, perform the steps below:
1. Stop Browser Security Plus Server
2. Execute the script changeDBServer.bat available under <Browser Security Plus Home>/bin directory. This invokes the Database Setup wizard.
3. Select Database Type as SQL Server
4. Specify the Host Name where SQL Server is installed
5. From the list of available SQL server instances, select the instance on which you wish to run the database.
6. You can choose to authenticate the database connection either using Windows Authentication or SQL Server Authentication. Choose the required authentication and provide the credentials.
7. Click the checkbox to enable NTLM authentication.
8. Have the "Migrate Data from Existing Database" check box enabled if you want to migrate your existing database to MSSQL.
  Note: This is applicable only if you wanted to migrate your existing database to MS SQL. If you are trying to create a fresh set up, then you can ignore this step.
9. Click Save to save and complete the SQL Server Configuration. It may be noted that it will take a few minutes to configure the settings on the SQL Server.
  
  Fig: Windows Authentication
  
  Fig: SQL Server Authentication
  Note :
  - One of the best practise recommended is to, Click Test to check whether a connection could be established with the given credential.
  - This might take several minutes, the size of your database determines the time taken.

You can start using Browser Security Plus which has been migrated from the previous location.