PCgoblin's Blog

Fixing everyday PC problems on my PC

Fix problem when ACT cannot open its database: The “.” computer could not be reached

Every few days, when I try to load ACT, this fails, and I get the message:

The “<HOSTCOMPUTER NAME>” computer could not be reached because the IP address”” could not be resolved. Verifying the “<HOSTCOMPUTER NAME>” computer is available on the network, that is has the correct IP address, and that Microsoft SQL Server is properly installed may resolve this issue.

In my case instead of “<HOSTCOMPUTER NAME>” I see just “.”, probably as I am running ACT only on my local PC.

Error message when attempting to load ACT

Error message when attempting to load ACT

The first time this happened, I fixed my immediate problem, as follows – but it kept recurring:

  • Click the Windows Start button, and then click Run. The Run dialog box appears.
  • Type services.msc into the Open field, and then click OK. The Services snap-in launches.
  • Locate the entry for SQL Server (ACT7). I noticed that the service has not started, in spite of being set as Automatic. I right-clicked and then selected Start.
SQL Server (ACT7) service has not started

SQL Server (ACT7) service has not started

So I began looking for a permanent way of stopping this happening again.

  • Click the Windows Start button, then click on All Programs, then on Accessories.
  • Right-click on Command Prompt, then select Run as administrator.
  • The command prompt will be displayed, with the window entitled Administrator: Command Prompt.
  • Type the following sc config MSSQL$ACT7 depend= "Disk", then hit the Return key

    Set SQL Server service for ACT to depend on the disk driver

    Set SQL Server service for ACT to depend on the disk driver

After this, you can check that the dependency is correctly set:

  • Click the Windows Start button, and then click Run. The Run dialog box appears.
  • Type services.msc into the Open field, and then click OK. The Services snap-in launches.
  • Locate the entry for SQL Server (ACT7). I noticed that the service has not started, in spite of being set as Automatic.
  • Right-click on this entry and select Properties.
  • Select the Dependencies tab. This now shows that the SQL Server service for ACT depends on Disk Driver:

    SQL Server now with dependency on Disk Driver service

    SQL Server now with dependency on Disk Driver service

(Technical note: After adding this dependency, registry key HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\MSSQL$ACT7 will contain a multi-string value (of type REG_MULTI_SZ) called DependOnService with the value Disk.)
Hopefully this cures your problem!
Advertisements

February 8, 2014 Posted by | Uncategorized | , , , | Leave a comment