Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Service connection tool in offline mode fails to prepare the usage cab if the site database runs on a named instance with a custom port


View products that this article applies to.

Symptoms

Consider the following scenario:

  • You use Microsoft System Center Configuration Manager current branch in your environment.
  • You use a named instance of Microsoft SQL Server for the site database of the central administration site or the stand-alone primary site.
  • The named instance of SQL Server uses a custom port. 

In this scenario, when you use the service connection tool to put your usage data into a .cab file, the following error message is logged in the ServiceConnectionTool.log file:

↑ Back to the top


Cause

This issue occurs because the service connection tool still tries to connect to the default port (1433).

↑ Back to the top


Resolution

To fix the issue, follow these steps before you use the service connection tool:

  1. On the computer that hosts the service connection point, open Registry Editor, and then locate the following registry subkey:

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\COMPONENTS\SMS_DMP_UPLOADER
  2. Right-click SQL Server Name, and then click Modify.
  3. Add ,<port number> to Value data, and then click OK. For example, if the SQL server name is sql01.contoso.com and the port number is 1367, the new value data becomes sql01.contoso.com,1367.
  4. Close Registry Editor.

After you complete the connect and import steps, restore the value data of SQL Server Name under registry subkey HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\COMPONENTS\SMS_DMP_UPLOADER to the original value.

↑ Back to the top


Keywords: MSSolve, kbContentAuto, CI76767, Service connection tool, sqlException 0x80131904, kb, kbsurveynew

↑ Back to the top

Article Info
Article ID : 4092691
Revision : 12
Created on : 4/26/2018
Published on : 4/26/2018
Exists online : False
Views : 899