thinksysinc
asked on
Cannot open Act database from remote computer
I am having issues with Act for Workgroups 9.0 not opening from a remote computer. If I am on the server where Act is installed the database opens fine but for some reason when I try to access it from a remote computer via a share it does not open. It was working and for some reason it stopped.
I thought that there might be something wrong with the server that it is running on so I moved the database files to another server and I still get the same error. Here is the error message the remote computer gets when it tries to open the database:
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 on your computer or server.
There is no firewall running on the server or the workstation. I have also tested accessing the share from the workstation to the server and it works fine. The user can create files and delete files without any issues.
Any help on this would be great.
Thanks!
I thought that there might be something wrong with the server that it is running on so I moved the database files to another server and I still get the same error. Here is the error message the remote computer gets when it tries to open the database:
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 on your computer or server.
There is no firewall running on the server or the workstation. I have also tested accessing the share from the workstation to the server and it works fine. The user can create files and delete files without any issues.
Any help on this would be great.
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
@GLComputing - That document was very helpful. My issue was with the SQL Browsing service. Thanks!
@SStroz - Thanks for the help.
@SStroz - Thanks for the help.
Most of these errors are caused by permissions or DNS issues. Make sure the remote user has full permissions to the database share and supplemental file folder. Also, without DNS ACT! won't be able to open the supplemental file folder. You should be able to ping the machine name. (C:\>ping servername).
Try that and report back your results.
Steve