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']
For MSSQL, you need to procure a separate license and configure the same to enable a connection to IT360.
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.
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:
Note: The system locale can be set from: 'Control Panel -> Region and Language -> Administrative -> Change system locale'.
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 newlyusing yourAdmin privileges.
Under Object Explorer,'Security -> Logins', right click the required named instance and select Properties. (Refer the below screenshot)
In the Login Properties window displayed, do the following and click OK:
Make sure that server Authentication is selected as SQL server Authentication, as ManageEngine IT360 currently supports SQL Server Authentication only.
Select Server Roles from the Select a page column and check whether the public and sysadmin roles are selected. If not select those roles.
Select User Mapping from the Select a page column and check whether master DB has Admin privilege, as shown below.
Now, again under the Object Explorer, right click the named instance (as shown below) and select Properties.
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)
Once the Services are running, execute the following steps by using the SQL Server Configuration Manager:
Navigate to 'Start -> Microsoft SQL Server -> Configuration Tools -> SQL Server Configuration Manager' (See the below screenshot).
From the left panel, select Protocols for SQLEXPRESS (as shown in the below screenshot).
Right click on each of the following Protocols. In the corresponding Properties window displayed, set Enabled=Yes:
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.