Home > Uncategorized > ACT 5.5 with the ACT Connector

ACT 5.5 with the ACT Connector


So I installed Microsoft Application Compatibility Toolkit (ACT) 5.5 and the Application Compatibility Toolkit Connector for SCCM and kept getting errors connecting to the ACT database…very frustrating!  But, after a while of searching I finally must have used the right key words and found the solution below.  I guess Microsoft will be releasing an update so this is a workaround for now.
 
 

Symptoms

You will see the following error when attempting to configure your ACT database:

Cannot connect to SERVERNAME.

[-2146232060] Invalid object name ‘ACT_Databases’.

An update will not be released to fix this issue at this time, but the following workaround is available:

Workaround

The following script can be used to configure ACT connector to work with ACT 5.5 install.

Syntax

ActConfig.vbs [Server] [Site code] [ACT Server] [ACT database] {Machine Account}

  • [Server] – Name of ConfigMgr server where ACT Connector is installed
  • [Site Code] – Three letter side code of ConfigMgr server where ACT Connector is installed
  • [ACT Server] – Name of SQL server where ACT is installed
  • [ACT Database] – Name of ACT database on SQL server (set during ACT install)
  • {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 (domainmachinaccount$) where the machine account name is the ConfigMgr server where the ACT Connector is installed.

ActConfig.vbs

Server = Wscript.Arguments.Item(0)
SiteCode = Wscript.Arguments.Item(1)
ActServer = Wscript.Arguments.Item(2)
ActDatabase = Wscript.Arguments.Item(3)

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

‘domainsmsserver$
If LCase(Server) = LCase(ActServer) Then
MachienAcct = ""
Else
MachineAcct = Wscript.Arguments.Item(4)
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

Advertisements
Categories: Uncategorized
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: