Database Prerequisites
CloudShell applications can work with SQL database.
In this article:
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:
Supported Express editions:
|
Notes:
|
Quali Server |
|
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: