12-14-2012 02:09 PM
Suddenly getting error "Cannot access database" Act 2011 has been working, changed nothing; but, now cannot open database. I've had this problem for a while; but, if I restarted the computer the database opened. Now that doen't work.
12-18-2012 03:23 PM
Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.
12-21-2012 01:42 PM
I tried following your instructions; but, when I right clicked on SQL Server (ACT7) "Windows could not start SQL Server (ACT7) on Local Computer." I got error code 3414.
Then I tried right clicking on SQL Server Agent (ACT7) and got error code 1068.
I tried putting both error codes into the search window but got nothing.
If I re-install the program will it overwrite my databases?
12-26-2012 07:33 AM
12-26-2012 03:44 PM
Hi Greg, I did not know that reinstalling the Sage ACT! software would't affect the SQL installation, I thought that the SQL was part of ACT. When restarting the computer I recently started get the following message:
"ACT! Outlook Synchronization Application is not running. Please run ACT! Outlook Synchronization Application from Windows Startup menu." I do not have Outlook installed in this computer and did not find it listed in the Startup menu.
As I wrote earlier when I try to start the SQL Server I get error message # 3414, when I try to open the SQL Server Agent I get error # 1068. I tryed looking both errors up on Google; but, answer.
I appreciate your help. Thnaks, Larry Margolis
PS: I know a Greg Martin that is a member of the SGI, is that you?
12-27-2012 06:59 AM
At this point, the main issue is the SQL error - you'll want to concentrate on it (resolving it will probably resolve the Outlook sync message).
Sage ACT! installs an 'instance' within SQL. If SQL is not found installed on the computer, Sage ACT! will install it. Because the uninstall cannot tell if other programs are also using SQL, it is not removed with the uninstall of Sage ACT! (prevent breaking other programs).
If no other programs are using SQL, the steps I would recommend are:
- uninstall Sage ACT!
- uninstall all components of SQL
- reboot computer
- install Microsoft SQL/ACT7 instance manually using article: KB Article 26994
- test SQL Server (ACT7) service to ensure it will start
- install Sage ACT!
- open database