Community
Showing results for 
Search instead for 
Do you mean 
Reply

Act 8! database could not be accessed error after windows updates

New Member
Posts: 12
Country: United Kingdom

Act 8! database could not be accessed error after windows updates

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???

Many thanks,

 

Mike

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Act 8! database could not be accessed error after windows updates

Did you turn of Windows Firewall?

Is the Terminal Server on the SBS server or a seperate machine?

New Member
Posts: 12
Country: United Kingdom

Re: Act 8! database could not be accessed error after windows updates

Hi Mike,

 

Many thanks for the quick reply.

 

There are no firewalls on either Machine - all ports report open.

 

And they are two seperate machines.

 

Mike

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Act 8! database could not be accessed error after windows updates

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.

New Member
Posts: 12
Country: United Kingdom

Re: Act 8! database could not be accessed error after windows updates

Hi Mike,

 

once again,many thanks!!

 

The command telnet server 1433 comes up with a balnk screen (So i assume it works!!)

 

Mike

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Act 8! database could not be accessed error after windows updates

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?

New Member
Posts: 12
Country: United Kingdom

Re: Act 8! database could not be accessed error after windows updates

Hi Mike,

 

sorry that took so long!!

 

Tried it, also restarted server - still same problem!!

 

Many thanks,

 

Mike

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Act 8! database could not be accessed error after windows updates

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.

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Act 8! database could not be accessed error after windows updates

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.

New Member
Posts: 12
Country: United Kingdom

Re: Act 8! database could not be accessed error after windows updates

Hi Mike,

 

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??

Kindest regards,

 

Mike