03-14-2010 03:51 PM
Hoping someone could assist with this or indicate whether others have had the same problem?
When attempting to attach a remote user database using the attach remote utility a ‘Class Not Registered’ error occurs and the database is not attached.
If the database is manually attached using SQL utilities the database attaches without issue and the remote user can run SalesLogix. However this is a tedious process and so we require the attach remote utility to work.
Configuration:
SalesLogix 7.5 SP2
Host server is SQL 2008 SE
Remote User SQL is SQL 2008 Express SP1
03-15-2010 09:53 AM
Is Attach Remote being set to to the correct instance of SQL? Also, I recently had trouble attaching a remote, and was successfull after uninstalling older versions of SQL (MSDE or SQLExpress Compact Edition). In theory you can have multiple versions of SQL on the machine, but that is not always the case.
03-16-2010 08:07 PM
03-17-2010 08:56 AM
The Attach Remote utility assumes the SQLExpress instance name is [machinename]\SALESLOGIX. If you have SQLExpress 2008, it may have been installed as a default instance or with a different instance name. Make sure Attach Remote is set to the right one.
03-17-2010 03:44 PM
Hi, as suggested, there was still MSDE installed on the environment which needed to be uninstalled. This helped resolve one issue however the 'Class not registered' was still evident. SQL 2005 backward compatibility was also required and installed which resolved the issue.
Thanks for all the assistance.
03-29-2010 09:34 AM