10-02-2013 05:54 PM
Version Sage ACT! Pro 2013 Version 18.104.22.168
Unable to access database because sql not functioning. Error message reads "windows could not start the sql server (act7) on local computer. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code 3414."
I see related posts but no solution. Any help appreciated - thanks in advance
10-02-2013 10:02 PM
I wasn't familiar with the 3414 error messag so I looked it up and that error is a result of trying to recover a SQL database and failing which probably means that the database needs to be repaired or you will need to restore from a backup. If you need to repair the database you will need to send it to Swiftpage to have it repaired or there are a few ACCs who can repair an ACT! database. I may be able to repair it for you. Contact me offline if you'd like me to take a look at it.
10-10-2013 09:56 AM
I just fixed this one for a client. Uninstalling and reinstalling SQL 2008 R2 SP2 fixed it. I didn't need to uninstall and reinstall ACT!.