Exception has been thrown by the target of an invocation

Product
Cognos Controller 8
Symptom

When opening controller after migration of the controller databases from SQL2000 to SQL2005 the following error occurs after providing login credentials;

“—Exception has been thrown by the target of an invocation”

Problem
In the event log of the controller application server the following entry can be found.

The VB Application identified by the event source logged this Application FrMiscST: Thread ID: 6108 ,Logged: Error occured at 9/14/2009 6:15:11 AM in FrMiscST, Error No=-2147217900, Source=Server Sub:Db_PushStruc(..) , Description=Cannot resolve the collation conflict between “Latin1_General_CI_AS” and “SQL_Latin1_General_CP1_CI_AS” in the equal to operation., HelpFile= HelpContext=0

Cause
The collation settings of the new server is different than the original one. For controller all the collation settings of the temp db and controller databases must be the same collation.

Solution
Create new SQL2005 instance or perform a complete new SQL2005 server installation with the correct collation. In this case “SQL_Latin1_General_CP1_CI_AS”