10-24-2008 04:06 AM
Hi and many thanks in advance!!
We have Act! Professional 8 running on our Microsoft Small Business Server 2003 which is accessed on 7 PC's and a terminal server.
This Monday, after the terminal server applied some windows updates we started getting the following error:-
"The datbase ********* 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"
We have run through all the Act! help on this, including
The share option is not enabled - it is and all the other PC's can access it.
The PAD file is damaged - recreated - still same and the same PAD works on all the netwroked PC's.
The installed version is different. All versions on network are version 8.02.82
Firewall / Anti virus blocking - turned them all off.
Microsoft SQL server 2005 installed - not.
Preferences file damaged - deleted and recreated.
Outlook 2003 with BCM installed - not.
Database is damaged - backed up, restored - not.
Act! program damaged - uninstalled / reinstalled - fine.
Then this morning one of the Windows XP PC's installed some Windows updates and this now has the same problem.
Has anyone else seen this problem / got fix???
10-24-2008 04:57 AM
Did you turn of Windows Firewall?
Is the Terminal Server on the SBS server or a seperate machine?
10-24-2008 05:00 AM
Many thanks for the quick reply.
There are no firewalls on either Machine - all ports report open.
And they are two seperate machines.
10-24-2008 05:10 AM
From the TS machine, can you open a CMD prompt and try:
telnet SBSserver 1433
If it comes up with a blank screen, it worked, so close it. If it fails, can you try
telnet IPaddress 1433
Use the IP address of the SBS server where ACT! database is.
10-24-2008 05:20 AM
Ok... that should mean it's not a firewall issue and SQL is ok. I know you said so, but nice to confirm :-)
Can you try (on the SBS) turning off the Share in ACT!, make sure the folder is no-longer shared in Explorer, then turning it back on?
10-24-2008 06:11 AM
Can you check that the users still have Full Control on the database share?
This issue may occur if there are multiple shares created for the database. To check for multiple shares, perform the following steps:
1. Click on the Windows Start button and then click Run. The Run dialog box appears.
2. Type compmgmt.msc in the Open field and click OK. The Computer Management Console launches.
3. Expand the Shared Folders and then Shares in the left pane.
4. In the right pane, ensure there is only listing for your database's Supplemental Files folder. If there are multiple shares listed for your database's Supplemental Files folder (for example: TestDB-database files1), right-click the extra share name and select Stop Sharing. Repeat this step until only one share exists for your database's Supplemental Files folder.
10-24-2008 06:14 AM
BTW: Did the Telnet work with servername or IPAddress?
This error can occur if the client machine cannot properly resolve the name of the computer hosting the database. This can be fixed by editing the .PAD file to indicate the IP address of the computer hosting the database rather than the network name. Follow the steps below to replace the computer name with the IP address on the .PAD file.
1. Locate the .PAD file being used to open the database.
2. Right-click the .PAD file, point to Open With, then select Choose Program. The Open With dialogue box appears.
3. Select Notepad and then click OK. The Notepad window appears.
4. Look for the section stating "host=". Within the quotation marks, replace the name of the computer hosting the database with it's IP address. (Example: host="192.168.0.1")
5. Click on the File menu at the top of the window, and click Save.
6. Close Notepad.
10-24-2008 06:27 AM
In the management console I have the following shares active:-
Share name Folder Path
ACT D:\Company Shares\ACT
ACT Templates D:\old unused data from old server\ACT\Templates
Act2 D:\Company shares\Act2
companydatabase files D:\Company Shares\ACT\Database\company-database files
As far as I can tell they are distinct folders!
Sorry for not being cleverer - does this make sense??