Hi

I have a SCCM 2007 (Windows 2008 R2) on server A and database (SCCM) on server B (SQL 2005) . I have ACT (Windows 2008 R2)on server C and database (for ACT) on server D (SQL 2005).

I try to install a connector ACT on my server A but i error: "Error=Cannot open database "database on server B" requested by the login. The login failed"

My question: Why a connector try to connect on database on server B, i need to connect on server D (Database ACT)?

Thanks

Hi,

I have had similar problems, and using this vbscript to configure the connector solved it:

http://blogs.technet.com/b/configurationmgr/archive/2009/07/01/support-for-act-5-5-with-the-act-connector.aspx

regards,
Jrgen

How to launch actconfig.vbs if ACT connector is not installed?

It can be caused by not registered SPN for SQL instance:

How to Configure an SPN for SQL Server Site Database Servers

Hi

I retry this morning, but i new error:

"Error=There is already an object named 'fn_SplitString' in the database"

Thanks

Hi

This morning, i retry to install ACT connector:

No problem to install a connector (a new report appears) but when i configure a connector (ACTServer\instance) i have error:

[2146232060] Invalid Column name "UIVersion" Invalid column name "VersionCreated Date"

Thanks

Yes, I know this is an old post, but Im trying to clean them up.

Did you solve this problem, if so what was the solution?

Since no one has answer this post, I recommend opening  a support case with CSS as they can work with you to solve this problem.