Community
Showing results for 
Search instead for 
Do you mean 
Reply

Error 1067 Windows could not start SQL (ACT7)...

Tuned Listener
Posts: 43
Country: USA

Error 1067 Windows could not start SQL (ACT7)...

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.
Administrator
Posts: 568
Country: United_Kingdom

Re: Error 1067 Windows could not start SQL (ACT7)...

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?
Tuned Listener
Posts: 43
Country: USA

Re: Error 1067 Windows could not start SQL (ACT7)...

I get the 1067 error message when I use that routine and click on SQL Server (ACT7)

Administrator
Posts: 568
Country: United_Kingdom

Re: Error 1067 Windows could not start SQL (ACT7)...

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.
Bronze Super Contributor
Posts: 1,609
Country: United_Kingdom

Re: Error 1067 Windows could not start SQL (ACT7)...

Jon's response and suggestion is good BUT...

 

I would recommend uninstalling Act! first before uninstalling the SQL ACT7 instance.

 

Then reinstall Act! which will auto install the SQL.


David Shaw
Act! Certified Consultant since 2001
Office:    +44 (0)1483 714507
Mobile: +44 (0)7977 567 318
E-Mail:    dshaw@act4u.org