Microsoft SQL Server requirements

A prerequisite for the installation is to have Microsoft SQL Server installed and configured. The following requirements must be met:

Install Microsoft SQL Server 2008 R2 or later, alternatively you can install Microsoft SQL Server 2008 R2 Express or later. Choose Mixed mode authentication during installation.

If you have Microsoft SQL Server already installed, set authentication to Mixed mode (SQL Server authentication and Windows authentication). To do so, follow the instructions in this Knowledgebase article.

details_hoverNOTE

If you want to use Windows Authentification to log in to Microsoft SQL Server, follow the steps in this Knowledgebase article.

Allow TCP/IP connections to the SQL Server. To do so, follow the steps in this Knowledgebase article from part II. Allow TCP/IP connections to the SQL database.

details_hoverNOTE

To configure, manage and administer Microsoft SQL Server (databases and users), download SQL Server Management Studio (SSMS).

We recommend that you do not install SQL Server on a Domain Controller (for example, if you are using Windows SBS / Essentials). We recommend that you install ESET Security Management Center on a different server or do not select the SQL Server Express component during installation (this requires you to use your existing SQL or MySQL Server to run the ESMC database).