Avast EP: Installing and configuring Microsoft SQL Server 2008 R2 Express

How to install and configure Microsoft SQL Server 2008 R2 Express for Avast Enterprise Administration?

Avast Endpoint Protection comes with a central web-based Avast Enterprise Administration which is based on a SQL database that serves as data storage for all the policies, security settings and client information. If you select to 'Use SQL Express' option during the installation of Avast Enterprise Administration, it will automatically download, install and configure Microsoft SQL Server 2008 R2 Express on your machine. But you might need to install SQL Server separately to have, for example, advanced control over its setup configuration. In such a case you have to install SQL Server prior to Avast Enterprise Administration. This article will guide you through the process of standalone installation and configuration of Microsoft SQL Server 2008 R2 Express, so that you can use it together with Avast Enterprise Administration.

Installation and configuration of Microsoft SQL Server 2008 R2 Express for use with the Avast Enterprise Administration

Before you begin the installation of Microsoft SQL Server 2008 R2 Express please ensure that:

  • You are logged in to Windows as Administrator or as a user with administrator permissions (for instructions refer to Windows help or documentation on Microsoft website, or contact your machine/network administrator),

  • All other programs in Windows are closed and not running (for instructions refer to your vendor's documentation),

  • Your previous antivirus software is fully uninstalled (for instructions refer to your vendor's documentation),

  • Microsoft Windows Installer 4.5 (or later) is already installed, because it's required in order to install and run Microsoft SQL Server 2008 R2 Express. If not, you will need to download it from Microsoft website and install it on your machine.

  • Microsoft .NET Framework 3.5 Service Pack 1 (or later) is already installed, because it's required in order to install and run Microsoft SQL Server 2008 R2 Express. If not, you will need to download it from Microsoft website and install it on your machine.

  • Microsoft Windows PowerShell 1.0 (or later) is already installed, because it's required in order to install and run Microsoft SQL Server 2008 R2 Express. If not, you will need to download it from Microsoft website and install it on your machine.

When you are ready, proceed as follows:

  1. Firstly download the Microsoft SQL Server 2008 R2 Express with Tools from the Microsoft website and save it to your machine (SQLEXPRWT_x64_ENU.exe for 64-bit editions of Windows, SQLEXPRWT_x86_ENU.exe for 32-bit editions of Windows).

  2. Run the downloaded setup file SQLEXPRWT_x64_ENU.exe (or SQLEXPRWT_x86_ENU.exe if 32-bit Windows edition is used). If you are logged in as a user with administrator permissions, right-click on the setup file and choose 'Run as administrator' from the context menu.

  3. From the menu on the left side of the 'SQL Server Installation Center' screen select 'Planning' and then click 'System Configuration Checker' on the right.
    Figure I. A

  4. The 'System Configuration Checker' will just verify whether your machine meets a minimum system requirements to install Microsoft SQL Server 2008 R2 Express.
    Figure II.A

    If there will be some error or warning message displayed, please check the prerequisites mentioned above or refer to Microsoft SQL Server 2008 R2 documentation on Microsoft website for further instructions how to fix the issue:

  5. After successful verification, i.e. without any errors or warnings, select 'Installation' from the menu on the left side of the 'SQL Server Installation Center' screen and then 'New installation or add features to an existing installation' on the right to invoke a setup process. Make sure there are no any other error or warning messages because the setup will check your configuration again.
    Figure III. A

  6. When the License Terms screen is displayed, read the license agreement, tick the checkbox 'I accept the license terms.' and click 'Next'.
    Figure IV. A

  7. The Setup Support Files will be then installed and when it completes, the 'Feature selection' screen will appear. Leave all default features selected or at least select 'Database Engine Services' with 'SQL Server Replication' and 'Management Tools - Basic'. You can also change shared feature directory, but leave it default, if possible, and click 'Next'.
    Figure V. A

  8. On the 'Instance Configuration' screen select the option 'Default instance' to automatically use the name MSSQLSERVER for the instance of SQL Server in both the 'Named instance' and 'Instance ID' fields. Then click 'Next'.
    Figure VI. A

  9. On the 'Server Configuration' screen change the Account Name for the SQL Server Database Engine to 'NT AUTHORITY\SYSTEM' and also Startup Type for the SQL Server Browser to Automatic, and click 'Next'.
    Figure VII. A

  10. On the 'Database Engine Configuration' screen select 'Mixed Mode (SQL Server authentication and Windows authentication)' to enter and confirm a password for the SA account. Also click 'Add...' and specify the group that you want to have unrestricted access to SQL Server. You should add at least Administrator. Then click 'Next' twice,
    Figure VIII. A

    ...and once the installation progress completes, click 'Close' to exit the SQL Server 2008 R2 Setup.
    Figure IX. A

Now you can restart your machine and then proceed with the installation of Avast Enterprise Administration. When asked, choose 'Use full MS SQL Server' to bypass automatic download and installation of Microsoft SQL Server 2008 R2 Express and to configure Avast Enterprise Administration with the existing SQL Server instance. For detailed instructions about installation of Avast Enterprise Administration please read the following article:

Additional configuration of the Microsoft SQL Server 2008 R2 Express to allow remote connection of the Avast Enterprise Administration

If you need to connect the Avast Enterprise Administration to the Microsoft SQL Server 2008 R2 Express remotely from another machine, you also have to configure the following:

  • Enable TCP/IP protocol in the network options of the Microsoft SQL Server 2008 R2 Express because it is disabled by default:

    1. In Windows, from the 'Start' menu select 'All Programs' or the 'Programs' sub-menu, then 'Microsoft SQL 2008 R2', then 'Configuration Tools' and then click on 'SQL Server Configuration Manager'.

    2. In the SQL Server Configuration Manager expand 'SQL Server Network Configuration' in the left pane to be able to select 'Protocols for MSSQLSERVER'.

    3. Then right-click on the 'TCP/IP' protocol on the right and select 'Enable' from the context menu.
      Figure I. B

    4. When it is done, close the SQL Server Configuration Manager.

  • Create exceptions in your firewall, if any is used, to allow access for the SQL Server and SQL Browser. These services are located in the following folders by default:

    • The SQL Server service:

       C:\Program Files\Microsoft SQL Server\MSSQL.10\MSSQL\Binn\sqlservr.exe 

    • The SQL Browser service:

       C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe 

    For more instructions refer to your firewall vendor's documentation, or if you are using Windows Firewall please read the documentation on Microsoft's website:

Once you have finished, you can configure the Avast Enterprise Administration during its installation to be connected to the Microsoft SQL Server 2008 R2 Express remotely from another machine. For detailed instructions about installation of Avast Enterprise Administration please read the following article:

Conditions

Avast Enterprise Administration 7.x

Avast Endpoint Protection
Avast Endpoint Protection Plus
Avast Endpoint Protection Suite
Avast Endpoint Protection Suite Plus

Microsoft SQL Server 2008 R2 Express

Operating systems:


Microsoft Windows XP Home / Professional / Media Center Edition
Microsoft Windows Vista Home Basic / Home Premium / Business / Enterprise / Ultimate
Microsoft Windows 7 Home Basic / Home Premium / Professional / Enterprise / Ultimate

Microsoft Windows Server 2003 (Any Edition, incl. Small Business Server)
Microsoft Windows Server 2008 (Any Edition, incl. Small Business Server, except Server Core)
Microsoft Windows Small Business Server 2011

Lo sentimos, este artículo no está disponible en el idioma seleccionado. ¿Desea continuar leyendo el artículo en el idioma actual o ir a la página de inicio en el idioma que ha elegido?

Continuar leyendo Ir a la página de inicio
X