Community
Showing results for 
Search instead for 
Do you mean 
Reply

ACT SQL SA password

New Member
Posts: 1
Country: USA

ACT SQL SA password

Does anyone know what or how I can figure out the SQL SA password for ACT?  I want to backup the live database file and need access via SQL Enterprise to add the appropriate windows server users.  My version is ACT! by Sage Premium for Workgroups 2006 Version 8.0.2.82.  Thanks!

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: ACT SQL SA password

There is an SA Password Utility that you can purchase from Sage... not sure if it's available still for ACT! 2006
Nickel Elite Contributor
Posts: 508
Country: USA

Re: ACT SQL SA password

Use the ACT! Scheduler to backup the ACT! database.  Not only is it built-in, it creates a zip file that is then easily added to any backup program/schedule.  Furthermore, if you do have a database issue, and need to restore a backup, restoring from the latest zip file is super-quick and easy vs. getting similar data from a detached SQL backup, or in your case, directly from SQL.

 

Hope this helps, they've made it as easy as possible to backup and restore if necessary, don't complicate it...

Richard Brust
ACT! Certified Consultant
richard@rbrDataSolutions.com