04-22-2013 08:16 AM
I would like to know if it is possible/recommended to run the Sage ACT! database without any Sage software on the database server. That is either create the database manually on the database server, or create the database using the Sage ACT! software on a test machine and manually copy the database to the database server.
I believe this is possible, but in reply to an earlier question I was advised that it is not recommended to run the database without ACT! software on the same server.
In our environment it would be a show-stopper if any application client/admin software had to run on our corporate production database servers.
Could anyone please direct me to any KB articles on the possible/recommended database architecture?
Thanks and take care,
04-23-2013 06:53 AM
You need to have an ACT SQL instance (doesn't require ACT software) but you also need to have the ACT program on the server. ACT will not work on a simple file server because the sql engine needs to be running.
If you are unable to get permissions to put ACT on your server, you could set up a simple peer to peer sharing of the database between two workstatiosn or consider hosting your database with a hosting provider.
04-23-2013 07:10 AM
04-25-2013 07:34 AM
Would you be able to tell me which Sage software (not MS) is required to run on: the database server, the web application server, the client? In an access via the web, multiple server architecture?
04-26-2013 06:06 AM
Unfortunately ACT! does not follow the classical n-tier architecture. You'll need to install the ACT! windows client software on each server/machine. You can choose to do a SQL-less install on the web server and the client machine.