Skip to main content
Version: 2023.3

Database Prerequisites

CloudShell applications can work with MS SQL database.

MongoDB database permissions and installation requirements

CloudShell uses MongoDB's official software and hardware requirements, as detailed in https://docs.mongodb.com/manual/administration/production-notes/. For your convenience, we've listed the minimum hardware requirements below. In case of a discrepancy, please use MongoDB's recommendations.

Minimum supported versions of MongoDB are detailed in Select the Database Type.

Minimum Hardware RequirementsDescription
CPU2 dual cores or 1 physical multi-core CPU
RAM4 GB
Hard Drive40 GB

SQL database user permissions

For initial CloudShell installation, provide Windows users and the NT AUTHORITY\SYSTEM user with the following SQL server roles:

  • bulkadmin
  • dbcreator
  • public
  • sysadmin - for the NT AUTHORITY\SYSTEM user only

When running CloudShell after installation, make sure your Windows users and the NT AUTHORITY\SYSTEM user have the following SQL server roles:

  • bulkadmin
  • dbowner
  • public

In addition, also provide a specific permission to "Connect to SQL" that is granted manually in the "Securables" section of the user's login properties.

For a detailed list of SQL server roles, see the Fixed Server Roles appendix.

Installation requirements for SQL databases

The required components must be installed in the following order:

Database

Supported Standard editions:

  • SQL Server 2012
  • SQL Server 2014
  • SQL Server 2016
  • SQL Server 2019

Supported Express editions:

  • SQL Server 2016 SP1

**Hardware requirements for SQL Server: **

 POC environmentTeam TierPremium Tier
CPU4 logical cores8 logical cores16 logical cores
Memory8 GB16 GB32 GB
Storage (hard disk)20 GB40 GB (SSD)100 GB (SSD)
Network card 1/10 GB, according to network load1/10 GB, according to network load

Installation instructions:

  • For production environments, use SQL Server in an AlwaysOn availability group configuration.
  • SQL Express edition should only be used for POCs. For details, see this Microsoft docs article https://www.microsoft.com/en-us/sql-server/sql-server-downloads.
  • Where there is an existing SQL server installed on the organization’s network, it is recommended that this is used.
  • When selecting the Standalone option in the CloudShell installer, if the CloudShell installer cannot find Microsoft SQL Server or Microsoft SQL Server Express on the destination environment, Microsoft SQL Server Express is installed automatically as part of the installation procedure.
Notes
  • There is a limitation of the maximum database size, per database - 10 GB for SQL Server 2016 SP1.
  • SQL Server 2012 Enterprise, SQL Server 2014 Enterprise and SQL Server 2016 Standard Edition are supported for High Availability (HA) solutions.

Quali Server

Installation instruction:

  • The Quali Server can be located anywhere on the organization’s network.
  • For a standalone installation, the Quali Server is installed on the same machine as the clients and the database.

CloudShell applications

Installation instructions:

Quali Server, SQL server or SQL Express, and the CloudShell applications can be installed on the same machine, or on separate machines in the same network.

Additional requirements