HELP - "database could not be accessed"

[davidehanna]

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?

[Roy_Laudenslager]

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.

[ghollister]

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...

[davidehanna]

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

[ghollister]

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...

[davidehanna]

Great.  Thank worked!!!!

Dave