12-03-2008 03:38 AM
For data protection reasons, we keep all our documents on a drive that is encrypted. This drive is not available until you run the software to mount the encrypted drive.
While we were running version 10, we had no problems accessing Act with our remote users having the database on the encrypted drive.
On version 11, we see the error message regarding that database can not be accessed and "In order to access this database, check your network connection and verify that your database server is available. "
Now if we set the SQL Server (ACT7) service to be manual. Start the SQL Server (ACT7) service after the encrypted drive is mounted, then Act does not display the error message.
So it looks like Act version 11 is not happy with the SQL Server (ACT7) service to start when the location of default database is on the drive which is not available. If you start the SQL Server (ACT7) service when the default database is available, then it starts each time.
Any suggested work arounds?
12-03-2008 03:13 PM
Maybe change the login for the service from Local System to an account that has access and maybe try seeting Recovery on failure to run the mount software and try again?
I'm actually surprised 10 would not have the same issue as SQL would need to see the drive when it loads... someone might have resolved this previously, so you might ask whoever installed 10
12-04-2008 02:26 AM
The SQL Server (ACT7) service is not failing since the demo database is available.
The issue is that the SQL Server (ACT7) service can not bring our database online since the drive is not available when the SQL Server (ACT7) service starts up.
Restarting the SQL Server (ACT7) service once the drive is mounted allows access to the database.
Nothing special was done on install of version 10 or version 11.
We just did not see the problem on version 10.