09-23-2008 07:22 PM
We have ACT! running on a SQL server, SERVER1. With the ACT! application installed on a frontend terminal server, CTX01.
Now when we try to access ACT! via the CTX01 we get:
"The database CompanyDB 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 the server."
There may have been some changes recently on the backend SQL server SERVER1, which affected network connectivity. Is it possible to specify the port number in the PAD file? (forgive me, I didn't know anything about ACT until this got to my desk).
Any help would be greatly appreciated!
09-23-2008 07:26 PM - edited 09-23-2008 07:56 PM
Hmm actually, when I connect to ACT! locally on SERVER1 and run the actdiag it comes up as a LPC connection rather than TCP - maybe this is why it works locally?
The SQL Server Browser service is running, however the DB is hidden - do we need to specify the port number in teh .PAD file?