Database Prerequisites

CloudShell applications can work with SQL database.

In this article:

SQL database user permissions
Installation requirements for SQL databases
Additional requirements

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

As SQL Server 2008 R2 is no longer supported by Microsoft, we recommend using a later version for your CloudShell database.

The required components must be installed in the following order:

Component	Installation instructions
Supported Standard editions: SQL Server 2008 R2 SP2 SQL Server 2012 SQL Server 2014 SQL Server 2016 Supported Express editions: SQL Server 2008 SQL Server 2016 SP1	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, 4 GB for SQL Server 2008 Express and 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	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	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.

Component

Installation instructions

Supported Standard editions:

SQL Server 2008 R2 SP2
SQL Server 2012
SQL Server 2014
SQL Server 2016

Supported Express editions:

SQL Server 2008
SQL Server 2016 SP1

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, 4 GB for SQL Server 2008 Express and 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

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

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

The Distributed Transaction Coordinator service must be running on the database server with specific configurations, as detailed in the Troubleshooting Guide:
- MSDTC Security Configuration
- MSDTC Firewall Settings

Community

University

Support