Installation (with SQL Server Express)

Workload Modeller installer now includes SQL Server Express and Management Console; this allows users to start working with SQL Server straight away if required.

The following SQL Server components are included as part of the SQL Express 2019 and SQL Server Management Studio installation.

  • Active Directory Authentication for SQL Server
  • Browser for SQL Server 2019
  • Microsoft ODBC Driver 17 for SQL Server
  • Microsoft OLE DB Driver for SQL Server
  • Microsoft SQL Server Express 2019
  • Microsoft SQL Server 2012 Native Client
  • Microsoft SQL Server 2019 Setup (English)
  • Microsoft SQL Server 2019 T-SQL Language Service
  • Microsoft SQL Server Management Studio - 18.4;
  • Microsoft VSS Writer for SQL Server 2019

Note: SQL Server Management Studio is also installed. This is required for management of the SQL Server Express Database. For more information see SQL Server Express and SQL Server Management Studio

The following are also created during the SQL Server Express installation:

  1. A user with the login sa, (password is revealed during installation). This is a system administrator account and has full privileges within the database. After installation, remember to:
    1. Change the sa password OR
    2. Create another administrative user and then disable the sa user
  2. A user called WorkloadModellerAdminUser, with a strong password generated during installation.
  3. A database called WorkloadModeller (can be renamed by the user during installation.)

Note: The WorkloadModellerAdminUser is the dbo (database owner) of the WorkloadModeller database created during installation.

Where to find Installation files

  • Visit the Downloads page on the Cadcorp website.
  • Select either 32-bit or 64-bit of Cadcorp Workload Modeller 9.1 and click Download.
  • This choice depends on the installed version of Cadcorp SIS Desktop. To check your version, simply open SIS desktop and select View > About > Product.

  • Check your system’s Downloads folder for an installation file with the name Cadcorp SIS Modelling 9.1.xxxx.32 (or 64) exe.

Note: The xxxx field in the filename indicates a minor version number.

  • Double-click the .exe to begin installation.

Installing Workload Modeller

  1. After launching the .exe, you will see this welcome screen. Click Next to begin.
  2. Take a moment to read through the Licence Agreement. Click I accept to proceed with installation.
  3. Choose between Complete (to install both Modelling tools- Risk Modeller and Workload Modeller) or Custom (to install either of the two modellers).

  4. Define a name for the database catalog and the server you are connecting to in SQL Server. (You can use the available suggestion or specify your own).
  5. Specify a strong password for administering the Workload Modeller database. Click Next.
  6. Click Install to begin installing Workload Modeller.
  7. Click Close when installation is complete.

Uninstalling Workload Modeller

Please note that uninstalling Workload Modeller will NOT remove SQL Server Express and Management Studio. These must be uninstalled separately.