Microsoft SQL Configuration

Introduction

This section is common to all the editions of IT360 - Professional Edition, Enterprise Edition (Both Central and Probes) and MSP Edition (Both Central and Probes).

This section explains in detail, the procedure to configure MSSQL in IT360:

  1. Things to Remember

  2. Prerequisites

  3. Steps to be performed in SQL Server Management Studio

  4. Steps to be Performed in SQL Server Configuration Manager

1. Things to Remember

  1. If the system locale or language in the system, in which the MS SQL is installed, is other than English, then 'Collation' is to be configured as: 'SQL_Latin1_General _CP1_CI_AS', as shown in the below screenshot:


Note: The system locale can be set from; 'Control Panel -> Region and Language -> Administrative -> Change system locale']

  1. For MSSQL, you need to procure a separate license and configure the same to enable a connection to IT360.

  2. For MSSQL installation in IT360 server itself, you need to consider the MSSQL-specific system / hardware requirements, in addition to the system / hardware requirements of IT360, for better performance.

  3. If the system locale or language in the system, in which MS SQL is installed, is other than English, then 'Collation' is to be configured as:

    'SQL_Latin1_General _CP1_CI_AS'

    Note: The system locale can be set from: 'Control Panel -> Region and Language -> Administrative -> Change system locale'.

Top

2. Prerequisites

Check the following conditions, before you proceed with the MSSQL Configuration:

  1. Open Services.msc and ensure that the following Windows Services are running:

Top

3. Steps to be performed in SQL Server Management Studio

Note: Ensure that you have proper privileges (i.e. Admin), before executing the steps given below. You can use the existing named instance or create newly using  your Admin privileges.
  1. Under Object Explorer, 'Security -> Logins', right click the required named instance and select Properties. (Refer the below screenshot)

  1. In the Login Properties window displayed, do the following and click OK:

    1. Make sure that server Authentication is selected as SQL server Authentication, as ManageEngine IT360 currently supports SQL Server Authentication only.

    1. Select Server Roles from the Select a page column and check whether the public and sysadmin roles are selected. If not select those roles.

    2. Select User Mapping from the Select a page column and check whether master DB has Admin privilege, as shown below.

  2. Now, again under the Object Explorer, right click the named instance (as shown below) and select Properties.

  1. In the Server Properties window displayed, click Connections from the Select a page column. Check if the Maximum number of concurrent connections is set to zero, if not set the same. (Note: Any change in this parameter requires a restart of the SQL server)

Top

4. Steps to be Performed in SQL Server Configuration Manager:

Once the Services are running, execute the following steps by using the SQL Server Configuration Manager:

  1. Navigate to 'Start -> Microsoft SQL Server -> Configuration Tools -> SQL Server Configuration Manager' (See the below screenshot).

  1. From the left panel, select Protocols for SQLEXPRESS (as shown in the below screenshot).

  2. Right click on each of the following Protocols. In the corresponding Properties window displayed, set Enabled=Yes:

  1. Now, right click on the TCP/IP protocol. In the TCP/IP Properties window displayed, click the IP Addresses tab. Make sure that the fields 'Active’, ‘Enabled’ and 'TCP Port' are configured with the values, as shown in the below screenshot, so that IT360 is able to connect to the SQL Server.

Note: The default value for the TCP Port is 1433; else enter the Port number, where MSSQL is running.

Top

Note:
  1. Use a prefix to identify the database, related to IT360, while configuring the database parameters.

  2. If SQL Server is installed on a remote server, you have to copy the following files from SQL Server installation to the [IT360_Home]\traffic\bin folder. (for example)

    C:\Program Files\Microsoft SQL Server\90\Tools\Binn\bcp.exe
    C:\Program Files\Microsoft SQL Server\90\Tools\Binn\Resources\1033\bcp.rll

  3. IT360 stores raw traffic data for a certain period of time. This data has to be periodically written to the remote database server, using SQL bulk copy tool - bcp.exe.

  4. Download the same version of MSSQL server Native Client and install it on the IT360 Server. This is required by IT360 to communicate to the remote database server.



Copyright © 2013, ZOHO Corp. All Rights Reserved.