I just reinstalled ACT Pro V17 on a Windows 32 bit computer from a Windows 64 bit and restored database. Upon attempting to open my database I got message that "...SQL Server is not running, ACT will try to restart.. take a few minutes." It did not start, so I tried to open database with result that is in subject line. I also got link to two possible solutions to manually start the SQL; neither worked, in both cases green bar stopped before completion. I have searched your site for similar problems/solutions but found nothing additional to try. FYI: The new computer has SQL 2014 on program menu; former computer, where ACT worked perfectly, has 2014 and 2008. I even tried downloading and installing 2008 unsuccessfully. I would greatly appreciate some help. WITHOUT ACT I AM DEAD IN THE WATER. Thank you.
Just to confirm there Bob, when you try to start the SQL Server (ACT7) service from the services window (Start Menu > Run > "services.msc") - the service doesn't start? Does it throw up any error messages when this happens?
Hmm, it does sound like the SQL Instance hasn't fully installed correctly. The easiest way to reinstall it, is to find the SQL 2014 (x86 / x64) item in the Programs and Features list, and remove it from there. You'd be looking for the one titled: Microsoft SQL Server 2014 (xx-bit) - and not any of the other secondary installations like "Native Client" or "Setup".
When removing the SQL instance, please make sure you only remove the ACT7 instance in the remove wizard.
Once you've done this, uninstall and reinstall Act! itself - this will recreate the SQL instance. I'd recommend doing this reinstall with your antivirus disabled, and logged into the PC as an administrator, if you aren't already.
If reinstalling this way doesn't work, there are other ways to fix the SQL Server, but they can be a little more complicated.