MSSQL Configuration

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).

ManageEngine IT360 supports both MySQL and MSSQL as the backend databases. MySQL is bundled, by default, in the product and is automatically installed, while installing IT360, hence no separate configuration steps are required, if you choose to use MySQL.

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']

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

3. 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.

4. 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:

   • SQL Server
   • SQL Server Browser

2. Ensure that you have proper privileges (i.e. Admin), before executing the steps given below.

Top

3. Steps to be performed in SQL Server Management Studio:

1. Under the Object Explorer, right click on the named instance and click Properties, as shown below.

2. In the Server Properties window displayed, select Security from the left panel. Now, on the right side, under Server Authentication, choose the option SQL Server and Windows Authentication mode. Click OK. (Refer the below screenshot)

3. Now again under the Object Explorer, under 'Security -> Logins', right click on the instance and select Properties. (Refer the below screenshot)

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

• Select Server Roles and check whether the public and sysadmin roles are selected. If not select those roles.

• Select User Mapping and check whether master DB has Admin privilege, as shown below.

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).

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

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

• Shared Memory

• Named Pipes

• TCP/IP

4. 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