05-12-2009 11:50 AM
One Remote user had the following issue on her Vista SP1 laptop:
The SQL Server (ACT7) service terminated with service-specific error 3414 (0xD56). (from Application event log)
The log scan number (28:336:1) passed to log scan in database 'model' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup. (from System event log, repeats)
The SQL Server (ACT7) service won't start. I'm just posting this here in case someone else has run across this. I'm goign to uninstall ACT 2009 completely and start over to resolve the SQL issue. That should fix this issue. However, I'd gladly accept recommendations from our technical buddies at Sage.
05-19-2009 06:16 AM
05-19-2009 06:16 AM
06-22-2010 08:08 PM
I uninstalled and re-installed and it didn't work. I finally got SQL Server ACT7 to install but it still will not start. I have uninstalled and re-installed the SQL, and I still have the same issue.
I have deleted the old registry additions, etc. I am running Windows 7 32-bit ultimate. Can anyone help?
06-23-2010 06:38 AM
To clarify, when I uninstall ACT 2009, I also uninstall the SQL instance associated with ACT. Sage also has a software tool that will completely remove all files and registry keys for ACT. I think it's called the ACT Removal Tool. In any case, I start with a fresh install of ACT through the normal install procedures that includes installing SQL as part of it.
Make sure you don't have SQL 2008 installed when installing the ACT SQL 2005 database. We've run into problems before where the SQL install fails under these conditions.
Vista Ultimate shouldn't be a factor in this software. If the SQL Service doesn't start, it's usually because of a corrupted SQL file, the computer name has changed, or the account that the service runs under has a problem. My two cents.