Community
Showing results for 
Search instead for 
Do you mean 
Reply

HELP - "database could not be accessed"

New Member
Posts: 10
Country: USA

HELP - "database could not be accessed"

I opened ACT and tried to connect to my database and got this error message: "In order to access this database check to verify your connection is working and It may be necessary to disable firewall, ect."  The database is there and I used it not too long ago and my connection is fine.  What's wrong and how do I fix this?

Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: HELP - "database could not be accessed"

Most likely the SQL server failed to start. Right click on My Computer and select manage and then browse to the SQL ACT7 service and see if it's started. If not start it.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: HELP - "database could not be accessed"

Detailed instructions for starting the SQL Server are in this Knowledgebase article:
http://kb.Sagesoftwareonline.com/cgi-bin/Sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=2821...

If this does not resolve the issue, additional causes/solutions are in this KB article:
http://kb.Sagesoftwareonline.com/cgi-bin/Sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=1964...

Greig Hollister

Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.

New Member
Posts: 10
Country: USA

Re: HELP - "database could not be accessed"

Thanks for the help.  I tried what you suggested, but the ACT SQL Server doesn't appear anywhere.  What next?  Thanks

Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: HELP - "database could not be accessed"

[ Edited ]

If you are trying to access a local database, you will need to install the SQL Server service. Instructions are in the Knowledgebase. Click the link for the article that applies to your version of ACT!:

ACT! 2007-2010 (SQL 2005):
http://kb.Sagesoftwareonline.com/cgi-bin/Sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=1938...

ACT! 2011 and higher (SQL 2008 R2):
http://kb.Sagesoftwareonline.com/cgi-bin/Sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=2699...

Greig Hollister

Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.

New Member
Posts: 10
Country: USA

Re: HELP - "database could not be accessed"

Great.  Thank worked!!!!


Dave