08-02-2012 08:24 AM
We aquired a new company that is using Act Premium. I moved the database from the old server to the new server but I am not installing Act or SQL on the new server. The users can see the DB and if they copy the ADF and ALF files to their local machine, the db will open. This is not a soultion since this is a shared db. I updated the PAD file to show the new server location and share location. We are still getting the same connection error
Error: "The database <Database name> could not be accessed. In order to access this database, check your network connection and verify that your database server is available. It may be necessary to disable any firewall software..."
I need some help please!!!
08-02-2012 09:08 AM
You need ot install the ACT! program which will also install the SQL Express server ACT! instance to actually open the database.
08-02-2012 09:17 AM
To answer your first question, no you must have ACT! and the SQL server installed on the server to share the database. Because you didn't specify the version of ACT! I can't say if your version of the ACT! program will run on the 2008 server. Either ACT! 2011 or 2012 will. If you have ACT! 2010 or before you should upgrade to ACT! 2013 which will release at the end of the month.
08-03-2012 10:31 AM
Ok so we are using 2011 version and I installed it on a 2003 server. I copied over the database folder and changed the PAD file to look at the new server and I still can't open it from the new server and it is local on the server. I get the same error:
Error: "The database <Database name> could not be accessed. In order to access this database, check your network connection and verify that your database server is available. It may be necessary to disable any firewall software..."Any ideas???
08-03-2012 11:37 AM
Is the ACT! instance of SQL running?
08-03-2012 11:45 AM
When you install the ACT! program on the server it installs an ACT! instance of SQL. That must be there and running to open the ACT! database. Check the services on the server for that.
08-03-2012 01:06 PM
Ok new error!!! "Cannot find database supplemental files folder SalesAndMarketing-database filesin this location PHFS1. This could be problem with the share, or the folder may not exist." The share exists. Basically, it is on the same exact server it was on before, just under a different share name.