10-14-2008 12:48 PM
Environment: Windows SBS 2003 R2 Premium, Act!2006 Version 18.104.22.168
I am trying to restore a backup to a new server and received the error
" Act.Data.DatabaseAccessExceoption: Failed to open a connection to the db. Act.Data.ActDB.ActdbException: Login failed for user 'ACTACCESS' . . . "
Act installed onto the new server without problems and can access an Act database installed on another server.
I'd appreciate any help with this problem.
10-17-2008 07:32 AM - last edited on 10-17-2008 01:06 PM by dlunceford
No I can't open a local database or create on either. I spoke to paid support and it turns out that this is a "known issue" described in
FAQ answer 17528
If you know of some workaround that doesn't involve removing service packs from SBS, uninstalling SBS,etc. please let me know. appreciate it.
Do you know whether these conflicts with Sharepoint, other SQL Server instances, Backup Exec and SBS SP1, occur in ACT 2008 and ACT 2009? It looks as though we're going to be forced to upgrade ACT to 2008 or 2009 (or come up with a workaround) and I'd like to be certain that these conflicts don't persist.
Content edit. Fixed link to improve scrolling.
10-17-2008 01:11 PM
ACT! 2008/2009 use SQL Server 2005, so there shouldn't be a conflict with your other SQL instances.
You can try uninstalling ACT!, disabling your other SQL instances and then installing ACT!.