Cloud DB for MSSQL quickstart

Available in Classic and VPC

Cloud DB for MSSQL on the NAVER Cloud Platform enables you to quickly and easily build MSSQL servers in a cloud environment and operate and manage them to provide stable database services. The overall workflow for using Cloud DB for MSSQL on the NAVER Cloud Platform is as follows:

Each step is described as follows:

1. Create an application server
2. Configure the connection environment
3. Test the application server connection
4. MSSQL Server creation
5. Configure the ACG
6. MSSQL Server connection test

1. Create an application server

First, create an application server (APP server) that will communicate with the MSSQL server you create in Cloud DB for MSSQL in the NAVER Cloud Platform console. Because Cloud DB for MSSQL is currently accessible only within the NAVER Cloud Platform, the application server must also be located within the NAVER Cloud Platform. You can create an application server (APP server) from > Services > Server in the NAVER Cloud Platform console.
For detailed instructions, see:

• Server getting started

2. Configure the connection environment

After you complete the application server creation, configure the connection environment so you can access the application server. There are two ways to configure the connection environment:

• Configure access by using port forwarding on the NAVER Cloud Platform (Classic environment)
• Configure access to the private domain using a public IP on the NAVER Cloud Platform (VPC environment)
  When you configure access using a public IP, check the administrator (root) password required to access the server by using the administrator password check feature.

For detailed instructions, see:

• Guide to checking server information and managing servers

3. Test the application server connection

After you complete the connection environment configuration, test whether you can successfully connect to the application server by using Remote Desktop Connection.
For detailed instructions, see:

• Getting started

4. MSSQL Server creation

After you complete the application server connection test, create an MSSQL server that will communicate with the application server. You can create a MSSQL server directly from > Services > Database > Cloud DB for MSSQL in the NAVER Cloud Platform console without submitting a separate service request.
For detailed instructions, see:

• Getting started

Server redundancy configuration

You can configure server redundancy to prevent data loss and minimize service impact in the event of a failure. Cloud DB for MSSQL creates a principal server and a mirror server and provides automatic failover to the mirror server if the principal server fails. Because redundancy is provided through a DNS-based method, no application changes are required.

To configure server redundancy, select High Availability support when creating the MSSQL server.

Monitoring and event management

You can monitor server performance and operating system status and review events for running MSSQL servers from the NAVER Cloud Platform console to manage cache services in a stable manner. You can also configure events, notifications, and alarms by using Cloud Insight on the NAVER Cloud Platform.

For detailed instructions, see:

• Monitoring
• Event

Administrative and operational permission management

In addition to the main account, you can create sub accounts to configure various management and operation permissions for Cloud DB for MSSQL. You can design permissions by using system-managed and user-created policies in Sub Account on the NAVER Cloud Platform.

For detailed instructions, see:

• Cloud DB for MSSQL permissions management

5. Configure the ACG

Configure the Access Control Group (ACG) of the MSSQL server so that the application server can access the MSSQL server.
For detailed instructions, see:

• ACG configuration guide

6. MSSQL Server connection test

Test whether you can successfully connect to the created MSSQL server by using an MSSQL client.
For detailed instructions, see:

• Getting started