SQL Server is a relational database management system (DBMS) developed and maintained by Microsoft, widely used for data storage and management. This topic shows how to deploy a SQL Server database on an ECS instance that runs Windows by using a marketplace image.
Prerequisites
You have added inbound rules to the security group of the ECS instance to allow traffic on TCP port 1433 and UDP port 1434. For more information, see Add a security group rule.
Port 1433: The TCP port that SQL Server uses to provide external services.
Port 1434: The UDP port used to obtain information about SQL Server, such as its TCP/IP port number and IP address.
This port is required only for the SQL Server Browser service. If you do not use this service, close or restrict access to UDP port 1434 to enhance security.
Procedure
-
Go to the Custom Launch page on the ECS console.
In the Image section, click Marketplace Image, and then click Select from Marketplace (including operating system).
In the Marketplace Image search box, enter
SQL Serverand click Search. Select the desired operating system and architecture, choose a specific image, and then click Use.This topic uses the
Windows Server 2019 with SQL Server 2019 Enterprise (includes 2024 security updates)marketplace image as an example. Click the image title to view its details and usage guides.On the Custom Launch page, the Images section is automatically set to the image you selected. Follow the on-screen instructions to complete the configuration and create the ECS instance.
Note the following items during configuration:
Assign a public IPv4 address to the instance.
Select the security group that you configured in the Prerequisites section.
Configure other parameters as needed. For more information, see Create an instance by using the wizard.
(Optional) Connect to the SQL Server database.
In the search box in the lower-left corner, enter
ssms.Click Microsoft SQL Server Management Studio 18.
In the Connect to Server dialog box, configure the server connection settings, and then click Connect.
Related documents
For a managed database service with high availability, reliability, security, and scalability, consider Alibaba Cloud ApsaraDB RDS. ApsaraDB RDS is a stable, reliable, and scalable relational database service that supports MySQL, SQL Server, PostgreSQL, and MariaDB engines. It provides comprehensive solutions for disaster recovery, backup, recovery, and migration.
You can use Data Transmission Service (DTS) to seamlessly migrate your self-managed databases to Alibaba Cloud databases. For more information, see Database migration solutions.