Reply
Astute Commentator
Posts: 12
Country: United_Kingdom
Message 1 of 22 (7,096 Views)
Accepted Solution

SQL Database Service not started

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

 

Regards

Bryan Rulton 

Please use plain text.
Platinum Super Contributor
gmartin
Posts: 5,276
Country: USA
Message 2 of 22 (7,093 Views)

Re: SQL Database Service not started

Hello Bryan,

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

 

 

 

Greg Martin
Sage
Please use plain text.
New Member
WJWodka
Posts: 1
Country: USA
Message 3 of 22 (6,281 Views)

Re: SQL Database Service not started

I am the SQL service is disabled, I try to retart or resume the program, but nothing seems to work.

 

What can i do?

Please use plain text.
Platinum Elite Contributor
ghollister
Posts: 6,537
Country: USA
Message 4 of 22 (6,272 Views)

Re: SQL Database Service not started

Hello WJWodka,
Welcome to the Sage ACT! Community. So is the SQL Server (ACT7) service installed, but you are unable to start it? What version of ACT! do you have installed? Also, what operating system does your computer use?

Greig Hollister
Sage

Note: Effective 6/1/13, Sage no longers provides support for the Act! software

Please use plain text.
New Member
brianb@cooled
Posts: 1
Country: USA
Message 5 of 22 (6,265 Views)

Re: SQL Database Service not started

I can not get my SQL service to start.  it says it started and stopped.  I can not open any databases from act.  Please help

Please use plain text.
New Member
RJacks
Posts: 6
Country: USA
Message 6 of 22 (6,100 Views)

Re: SQL Database Service not started - Act pro 2012

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.

any suggestions.

 

Please use plain text.
Platinum Super Contributor
gmartin
Posts: 5,276
Country: USA
Message 7 of 22 (6,086 Views)

Re: SQL Database Service not started - Act pro 2012

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.

 

Greg Martin
Sage
Please use plain text.
New Member
jacksonreg
Posts: 4
Country: USA
Message 8 of 22 (6,084 Views)

Re: SQL Database Service not started - Act pro 2012

Thanks Greg.

However the issue is more than this.

I just posted another error problem re: Outlook 2010 AND Act ver 14

Please use plain text.
New Member
staceyg13
Posts: 2
Country: USA
Message 9 of 22 (5,673 Views)

Re: SQL Database Service not started

Greg,

 

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?

 

Stacey

Please use plain text.
Platinum Super Contributor
gmartin
Posts: 5,276
Country: USA
Message 10 of 22 (5,659 Views)

Re: SQL Database Service not started

Hello Stacey,

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

Greg Martin
Sage
Please use plain text.