SCCM ACT Connector error -2146232060 (ACT 5.5)

You see error -2146232060 when attempting to configure your ACT database using the following steps:

1. In the Configuration Manager console, navigate to
   System Center Configuration Manager / Site Database / Computer Management / Application Compatibility Toolkit Connector/ Application Compatibility Toolkit Server
2. To open the properties of the ACT server right-click the ACT server in the results pane and select Properties. Alternatively you can select Configure ACT Server in the Actions pane or click the Actions menu and select Configure ACT Server.
3. To specify the Microsoft SQL server that contains the ACT database type the name of the server and click the Connect button. Alternatively, you can click the drop down and select Browse for more to open the Select Server dialog box. Select the server you want to use and click OK.
4. Specify the ACT Database to connect to using the drop down and selecting the database.
5. To close the ACT Configuration properties dialog box, click OK.

At this point you receive the following error:

Check Connection

Cannot connect to COMPUTERNAME.

[-2146232060] Windows NT user or group ‘DOMAIN COMPUTERNAME$’ not found. Check the name again.

‘DOMAIN COMPUTERNAME $’ is not a valid login or you do not have permission.

Microsoft will not be releasing a fix but the following modified script can be used to configure ACT connector to work with ACT 5.5 install, just change XXXX in the script as per the comments.

Server = "XXXXXX"    '<- Name of ConfigMgr server where ACT Connector is installed
SiteCode = "XXX"    '<- Three letter side code of ConfigMgr server where ACT Connector is installed
ActServer = "XXXXXX"    '<- Name of SQL server where ACT is installed
ActDatabase = "XXXX"    '<- Name of ACT database on SQL server (set during ACT install)
MachineAcct = ""    '<- Machine Account (Optional parameter)!  If the ACT is installed on different
'   server than the ACT Connector, then provide the machine account name the ACTC
'    provider runs under (domainmachineaccount$) where the machine account name is
'    the ConfigMgr server where the ACT Connector is installed.

Set objWMIService = GetObject("winmgmts:{impersonationLevel=impersonate}!\" & Server & "rootsmssite_" & SiteCode)
Set wbemObjectSet = objWMIService.InstancesOf("SMS_ActConfig")

'domainsmsserver$
If LCase(Server) = LCase(ActServer) Then
MachineAcct = ""
End If

For Each wbemObject In wbemObjectSet
wbemObject.Server = ActServer
wbemObject.Database = ActDatabase
wbemObject.Put_
If MachineAcct = "" Then
wbemObject.AddLinkedServer ActServer, ActDatabase
Else
wbemObject.AddLinkedServer ActServer, ActDatabase, MachineAcct
End If
Next

If Err.Number = 0 Then
msgbox "Success"
Else
msgbox "Failure " & Err.Number
End If

The original script can be found here Support for ACT 5.5 with the ACT Connector