Home → End User Setup → Optional Components → SQL — Do I Need to Install It?
Disponible en español: SQL – Es necesario instalarlo?
Disponível em português: SQL — Preciso instala-lo?
Applies to: @RISK 5.x–7.x
At the end of my install of @RISK or The DecisionTools Suite, I see the Finish button but I also see an option to install SQL. How do I decide whether to install it or not?
SQL is optional. You may or may not need it if you want to use the @RISK Library feature of @RISK's Professional and Industrial Editions. Only the @RISK Library feature depends on SQL; no other features of @RISK and none of the other DecisionTools Suite applications use SQL. The Library feature is not present in version 8 of @RISK.
The @RISK Library lets you store customized probability distributions and simulation results. You can reuse these model components and share them with other users. (@RISK simulation results can also be stored in the Excel workbook or in an external .RSK5 file, but the @RISK Library makes it easier to manage them.) See "Library" in the video Guided Tour of @RISK; the Library is similar in other @RISK versions.
Here's your road map for deciding whether to install SQL:
If you don't want to use the @RISK Library feature, don't install SQL. (If you later change your mind and want to use the @RISK Library, you can install SQL then, with no need to reinstall @RISK.)
If you have @RISK Standard, don't install SQL. The @RISK Library feature that uses SQL is not available in @RISK Standard Edition.
If you want to use the @RISK library with @RISK 6.2.0 or later, you need SQL Server only on the computers that host SQL databases. If databases are on the local computer, it needs an SQL Server. If all databases are on remote computers, the local computer can have SQL Server or SQL Native Client. (The remote computers that host @RISK Library databases don't need @RISK.)
See SQL Versions and Installation: SQL with @RISK 6.2 and later.
If you want to use the @RISK Library with @RISK 5.0 through @RISK 6.1.2, you need to install SQL Server on the local computer even if the database(s) will all be on remote computers.
See SQL Versions and Installation: SQL with @RISK 6.1 and earlier.
See also: SQL for @RISK Library on Another Computer
Last edited: 2020-03-19