HomeTroubleshooting@RISK for Excel: Library"The @RISK Library is not available because a connection ..."

7.6. "The @RISK Library is not available because a connection ..."

Applies to:
@RISK 5.x, Professional and Industrial Editions

Problem:
I downloaded and installed SQL according to your instructions. I have the @RISK Library set to Enabled in my Application Settings. But when I try to use the Library, I get this message:

The @RISK Library is not available because a connection to an SQL Server could not be established.

Solution:
First, do you actually have SQL Server 2005 Express installed? Please check in your Windows Start Menu. If it's not there, please follow the directions at http://www.palisade.com/support/sql92847.asp to install it.

If you do have the right version of SQL installed, then for some reason @RISK is timing out in its attempt to reach the SQL server. The solution is to increase the timeout interval. This article explains how to do that, either by editing the System Registry directly or by running a Registry update file. (Use either method, not both.)

Method A: Edit the System Registry

  1. Click Start » Run, type Regedit, and click OK.
  2. Navigate to HKEY_CURRENT_USER\Software\Palisade\RiskLibrary\5.0\Settings
  3. In the right-hand panel, right-click on an empty space and select New » DWORD.
  4. Rename the new item to ConnectionTimeoutCustom (capitalization as shown, and no spaces).
  5. Double-click ConnectionTimeoutCustom and enter the value 25.
  6. Close Regedit and run @RISK.

Method B: Registry Update File

  1. Download the attached file to your desktop.
  2. Rename the saved file to LibraryTiming.reg.
  3. Double-click the LibraryTiming.reg file. When asked "Are you sure", answer Yes.

last edited: 2010-07-23

Downloads

This page was: Helpful | Not Helpful