06-15-2010 10:07 AM
If you have other questions just post them around here. I'm just a regular user but there a lot of very knowledgeable people on this board (the other Greg, for instance).
02-06-2013 05:21 PM
Will all of this (using TrueCrypt) still work with ACT! 2012 in Windows 7?
And what about using the Windoews 7 BitLocker option to encrypt everything?
I, too, need to meet HIPAA encryption requirements (in the event of the theft of my hard drive).
Passwords alone no longer meet their standards as I have had it explained to me.
02-25-2013 07:44 PM
Thank you, GregH.
I am using Windows 7 Home Premium 64bit operating system.
In reading your previous posts here can you suggest what batch file commands are needed to stop and start the SQL for Sage ACT! Pro 2012 Version 14.0.572.0, Hot Fix 2 (which is what I have currently)?
I really need to get this thing under control and am just coming p to speed on the use of TrueEncrypt.
Thank you for any further suggestions or guidance you can offer!
02-26-2013 12:32 PM
GregH, sorry you are not still using ACT! Thank you for responding anyway.
I hoped someone could claify the correct way to write the correct code since I understand these are no longer correct:
NET STOP MSSQL$ACT7
NET START MSSQL$ACT7
I suspect I am very close to making this work but am really hesitant to make some mistake that will effectively lock me out of my ACT! program.
That would essentially kill my business right there. No need to worry about encryption requirements from HIPAA then!!
Any suggestions from anyone would be deeply appreciated!
I am still amazed that ACT! hasn't simply done something to spell out how to do this step-by-step for non-IT customers like me in view of the fact that HIPAA requirements for encryption are a business reality.
02-26-2013 01:43 PM
I believe you'll be okay unless the ACT SQL instance name has been changed. A safe way to find out is to make a copy of your database inside your TrueCrypt volume, call it "Test" or "HereGoesNothing" or something equally clever.
1. Click on the Start Button in Windows and type in "cmd" (without the quote marks). Press Enter and you'll find yourself at the command line.
2. Type: NET STOP "SQL SERVER (ACT7)" (with the quotes) and press Enter.
You should see text appear on the screen informing you that the service was stopped successfully. If that works then the command is working with your version/implementation of ACT.
3. Type: NET STOP "SQL SERVER (ACT7)" and press Enter. You should see the service starts up.
4. Type: exit to close the command line window and return to Windows.
5. Load ACT and try to open your HereGoesNothing test database.
If it works then create batch files by opening up Notepad and typing the NET STOP command in and save it as StopSQL.bat or whatever name you'd like as long as it ends in .bat. Put both NET commands on separate lines into another file and name it ReStartSQL.bat.
Then all you have to do is mount your TrueCrypt volume and run ReStartSQL.bat to get the SQL service up and running. Use StopSQL.bat to shut down SQL before dismounting the volume in TrueCrypt.
Test it and see if it works for you.