Autointegration Error when installing or upgrading Service Management

Document ID : KB000004706
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

When installing or upgrading Service Management with a custom instance of SQL you may receive the message below during the Integrating the Products step.

"Installation and Configuration completed successfully. However there were some errors during the autointegration."

Autointegration Error.png

Environment:
Service Management 12.9Service Management 14.1
Cause:

When a custom instance of SQL is created a new dynamic database port is assigned to that instance.

Port 1433 should still be valid and assigned to the default SQL instance. 

Database Configuration.png

Resolution:

Since port 1433 is a valid database port you will not receive an error during the Database Configuration portion of the installation.

However if you have entered a Database Server Instance, port 1433 should not be the default port.

You can verify the port number the Database Server Instance is using by:

  • Opening SQL Server Configuration Manager
  • Expand SQL Server Network Configuration in the left hand pane
  • Select your instance of SQL
  • Right click on TCP/IP and select Properties.

Select the IP Addresses tab and here you will be able to see the TCP port your instance of SQL is using.

By default a Dynamic Port will be assigned to a custom instance, otherwise 1433 will be the default port.

The port set for your instance of SQL will need to be entered in the Database Port field during the Database Configuration portion of the installation.

SQL TCP IP Properties.png