Asset import failed with the following error message "Only the 32-bit version of Microsoft SQL Server Compact Edition is installed. Install the 64-bit version of the server with the version number, v3.5.5692.0 on the CCS Application Serve" even though the server is running a 64-bit edition of SQL 2008 Enterprise.
Symantec recommends to install the sql server compact editon 64-bit and reboot the App Server. It can be downloaded from
http://www.microsoft.com/download/en/details.aspx?id=5821