Learn how to deploy and configure a SQL Server Community Edition service instance in a cloud environment.-Compute Nest(Compute Nest)-阿里云帮助中心

Overview

SQL Server is a relational database management system (DBMS) developed and maintained by Microsoft. It is widely used by enterprises and organizations for data storage and management.

Deployment

Go to the Compute Nest SQL Server Community Edition deployment link. On the Create Service Instance page in the Compute Nest console, specify a service instance name, select a region such as China (Hangzhou), and choose a billing method (pay-as-you-go or subscription). Configure other parameters, including instance type, instance password, Enable public IP address, operating system type, database configuration, and zone configuration. The configuration list on the right shows the real-time status of each parameter.
After you configure the parameters, the pricing details appear. Review your settings and click Next: Confirm Order.
On the order confirmation page, agree to the terms of service and click Create Now to start the deployment.
Wait for the deployment to complete. The status of the service instance changes to Deployed. On the Overview tab for the service instance, find the public and internal endpoints in the Use Now section to connect to your database.

Usage

Connect to SQL Server (Windows)

Use Workbench to log on to the Windows instance via RDP.
In the search bar in the lower-left corner, enter ssms.
Click Microsoft SQL Server Management Studio 18.
In the Connect to Server dialog box, enter the server connection information and click Connect.

Connect to SQL Server (Linux) and disable the sa account

To improve security, create a new account and disable the 'sa' account after your initial logon.

Connect remotely to the ECS instance. For the initial logon to SQL Server, use the 'sa' account:
```
docker exec -it sqlserver /opt/mssql-tools18/bin/sqlcmd -No -S localhost -U sa
```
Parameter description:

-S: Specifies the server name or IP address.

-U: Specifies the username.
Create a new login.
```
CREATE LOGIN <YOUR_USER> WITH PASSWORD = '<YOUR_PASSWORD>';
```
Replace <YOUR_USER> with the new username.

Replace <YOUR_PASSWORD> with the password for the new user.

Run 'GO' to execute the statement.
```
GO
```
Grant the sysadmin role to the new user.
```
ALTER SERVER ROLE sysadmin ADD MEMBER <YOUR_USER>;
```
Run 'GO' to execute the statement.
```
GO
```
Disable the 'sa' account.
```
ALTER LOGIN sa DISABLE;
```
Run 'GO' to execute the statement.
```
GO
```

Verify the changes.

SELECT name, is_disabled FROM sys.server_principals WHERE name IN ('sa', '<YOUR_USER>');

Run 'GO' to execute the statement.

GO

The following sample output shows the result for a user named 'admin'. A value of 1 for 'is_disabled' indicates that the 'sa' account is disabled, while 0 indicates that it is enabled.

1> SELECT name, is_disabled FROM sys.server_principals WHERE name IN ('sa', 'admin');
2> GO
name                                                                                                                            is_disabled
-------------------------------------------------------------------------------------------------------------------------------- -----------
sa                                                                                                                                        1
admin                                                                                                                                     0

For more information, see the SQL Server official documentation.