07-31-2017 01:13 PM
This is a twist on a problem already addressed in this forum. I have ACT! Premium 2010. After changing the computer name where a remote database resides it is no longer possible to do a network sync with the main database which is on another computer. When trying to sync I get an error code which says " The SQL Database instance is unavailable. Contact your administrator for assistance."
The normal fix would be to Tools \ Synchronization Pane l\ Manage Main Database Location. However, all the admin tasks in that box are grayed out. Any suggestions?
08-01-2017 02:21 AM
Changing the database location can only be done in a remote database. Therefore greyed out.....
In order to get the database location updated on the server, you need to detach/attach the database on the server.
08-14-2017 11:26 AM - edited 08-14-2017 11:28 AM
Andreas I assume you are referring to the SQL Server on the remote database. Using Actdiag I have detached the database and when I try to reattach it I get, "You don't have permission to open this file. Contact the file owner or an administrator to obtain permission". Please help I need that data in this file.
08-14-2017 08:20 PM
Could you check the SQL Server (ACT7) service (run 'service.msc') and select the Log On tab.
The 'Local System Account' box should be checked.