SQL Server - Features
Architecture
Regions
SQL Server is available on both cegedim.cloud's data centers:
EB4 - Boulogne-Billancourt, France
ET1 - Labège, France
Hosting and Versions
| Hosting type | SQL Server version | Operating System | SQL Server edition |
|---|---|---|---|
Virtual | 2022 | Windows Server 2022 | Standard or Enterprise |
Virtual | 2019 | Windows Server 2019 | Standard or Enterprise |
Virtual | 2017 | Windows Server 2019 | Standard or Enterprise |
Virtual | 2016 | Windows Server 2016 | Standard or Enterprise |
File system
Filesystem layout:
| Drive | Label | Default size | Description |
|---|---|---|---|
D:\ | MSSQL | 30 GB | Root instance |
E:\ | MSSQL_USER_DATA | 30 GB | User databases |
F:\ | MSSQL_USER_LOG | 10 GB | User databases log |
G:\ | MSSQL_TEMPDB | 10 GB | TempDB |
Virtual machine name restriction
Due to prefixes applied to Active Directory objects, the name of the virtual machine provisioned is restricted to 13 characters maximum for a cegedim.cloud PaaS SQL Server.
Ports
Ports listing:
| Port | Description | Protocol |
|---|---|---|
1433 | Server static port listener | TCP |
1434 | SQL Server Browser | UDP |
2382 | SQL Server Analysis Services Browser | UDP |
2383 | SQL Server Analysis Services listener | TCP |
5022 | SQL Server BDM/AG Endpoint | TCP |
Only the SQL Server listener and SQL Server Browser ports are opened inbound in the Windows Firewall by default and enforced through a GPO on the Organization unit.
Modules installed
List of modules installed by default during provisioning:
Database engine
Replication
Full-text Search
Client tools connectivity
SDK
Features
This section is to list which feature / capabilities are available to customer, and how to request / perform them:
Self Service | Customer can perform action autonomously. |
On Request | Customer can request for the action to be done to cegedim.cloud support team. |
| Features | Self Service | On Request | Comments |
|---|---|---|---|
Database Collation |
| ||
Integration Services |
| ||
Analysis Services |
| ||
Reporting Services |
| ||
Full-Text Search |
| ||
Export, Import SQL Server backup |
| ||
Create Always On cluster | Contact your Service Delivery Manager |
Security
System login
The SQL Server PaaS runs exclusively in a Windows environment. The standard system login method is RDP (Remote Desktop Protocol).
In order to connect to the virtual machine, you need to have the required privileges either at the domain level or at the local machine level.
Instance login
Authentication is configured by default in mixed mode which provides two login types:
SQL Server login: instance level
Active directory user: domain level - Embedded Windows authentication
Instance login is available locally or remotely:
Locally: once connected in RDP, launch the local SQL Server Management Studio
Remotely: launch the SQL Server Management Studio and specify the target instance
Locally
SSMS can use the Windows user credentials you're already logged with through RDP to login to the SQL Server instance.
Authentication with an SQL login is also possible locally.
Remotely
Specify a target instance in the server name field enforcing the tcp protocol: tcp:HOSTNAME\INSTANCENAME
Just select "SQL Server Authentication" and provide the SQL Login with the associated password.
Authorizations
Authorizations for cegedim.cloud teams are managed by GPO.
Authorization and passwords
This section list the password management for the SQL Server PaaS:
| Password | Stored by cegedim.cloud | Stored by Customer | Enforced |
|---|---|---|---|
admin account | |||
ANY other account | |||
cgdm_admin account | |||
monitoring account |
Customers
Authorizations for customers are managed by the customers itself.
The customer that request a SQL Server instance through ITCare will be automatically granted to connect on the instance. He can grant access to any Active Directory user or group afterwards.
Patching
Patchs are installed during "Patch parties" managed by cegedim.cloud every quarter.
An instance can be patched manually exceptionally if security or bug fixes requires it.
Data location
Datas for cegedim.cloud's SQL Server PaaS are stored on the dedicated virtual machines created upon requesting a PaaS.
These virtual machines and the storage associated are hosted and managed in cegedim.cloud's own data centers.
Last updated