08-03-2010 07:00 AM
I'm currently running ACT! by Sage 2008 (10.0) Version 10.0.2.191 on my laptop and PC.
I've attempted a 'restore as' but get a long script error message on the PC starting with "Act.Data.DatabaseAccessException: The SQL Database Service is not started......"
Any help would be greatly received
Solved! Go to Solution.
08-03-2010 07:21 AM
Welcome to the Act! Online Community!
To check the SQL service:
- click on Windows Start button
- on XP > select Run
- on Vista/Win7 > use the Search field
- enter the command 'Services.msc' > hit enter
- on the Services screen scroll down to 'SQL Server (Act7)' > check the Status column
- if blank > right click on the service and select Start
- attempt restore
07-05-2011 06:55 AM
09-22-2011 09:11 AM
have Act Pro 2012 - ver 14.0.572
was installed yesterday.
this am I try to open & get msg. SQL database Service is not started.
I did the suggested search. services.msc
no SQL server comes up. 12 other files only.
09-23-2011 09:03 AM
Locating the SQL Server (ACT7) service isn't actually a search for a file, if you are running Windows Vista or Windows 7 you will use the Search field and enter the command 'services.msc'. Pressing the Enter key with that command entered should bring up the Services screen.
An alternate method for Windows 7: right click on Computer icon > select Manage > expand Services and Applications > click on Services. List will be presented in column to the right.
Locate 'SQL Server (ACT7)' > right click on it and select 'Start' or 'Restart'. When complete, attempt to open database.
12-05-2011 01:03 PM
I too am having the same error. I follow your directions, the SQL Server (ACT7) shows start but it does not finish. I try to open ACT and get the error again. Can you help?
12-06-2011 07:28 AM
Welcome to the Sage ACT! Online Community!
First - did this ever work?
Since you are able to locate and attempt to start the SQL Server (ACT7) service, it appears the Microsoft SQL Server program is installed but may be blocked from starting by the firewall. Here is an article with exceptions to add to your firewall: KB Article 25125