You are attempting to access a shared Act! database from a workstation and receive the following error:
"The SQL Database instance is unavailable. Contact your administrator for assistance."
Product Family: Act!
Product: Act! Pro, Act! Premium
Version: 2010 and later
This can occur when the host computer name is not correctly resolved through the network. Use the following instructions to resolve this issue:
Option 1 - Add Exceptions to Firewall:
- Add exceptions to the firewall using the information in the following knowledgebase article:
Using your anti-virus/firewall software with Act!
Answer ID Using your antivirus/firewall software with Act!
- Attempt to access database
Option 2 - Update PAD File:
- Locate the .PAD file used to open the database.
- Right-click on the .PAD file, select Open With, select Choose Program. The Open With dialogue box appears.
- Select Notepad and click OK. The Notepad window appears.
- Locate 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")
- Click on the File menu at the top of the window, and click Save.
- Close Notepad.
- Attempt to open the database.
Option 3 - Start Services:
- Click the Windows Start button:
- For Windows XP, select Run.
- For Windows Vista® and Windows® 7, use the Search box.
- Enter command services.msc, press Enter key
- Locate SQL Server Browser and SQL Server (ACT7)
- If the Status for either is Started, right-click on each service and select Restart
- If the Status field for either is blank, right click on the service and select Start
- Once started, attempt to open your database
Option 4 - Reset SQL Password:
In some cases this issue may also be resolved by resetting the Microsoft® SQL Server® password on the machine hosting the database. Follow these steps:
- On the server, click the Windows® Start button, either click Run or go to the Search box, then type actdiag. The ACT! Diagnostics utility will open
- In ACT! Diagnostics, click Server, then select Server Security
- Click the Reset SQL Password button. Click OK to accept.
- Test opening the shared database on a client machine.