Getting started with Cloud DB for MSSQL

Available in Classic

The Getting started with Cloud DB for MSSQL guide describes what you need to do to properly use Cloud DB for MSSQL after checking the Cloud DB for MSSQL use environment and supported specifications and fully understanding the Overall usage scenario and Glossary. The following is the content dealt with in Getting started with Cloud DB for MSSQL.

• How to create an application server from the NAVER Cloud Platform console
• How to test application server connection
• How to create MSSQL servers from the NAVER Cloud Platform console
• How to test MSSQL server connection

If you completed the above, then you've completed the basic procedure for using Cloud DB for MSSQL. Afterward, you have the option of proceeding with the following tasks for more efficient server management and operation.

• Management of administration permissions using NAVER Cloud Platform's Sub Account

The above tasks can be done from Sub Account after requesting subscription, rather than in Cloud DB for MSSQL. They are not explained in detail in this guide. Refer to Sub Account Guide for detailed instructions for use.

Create application server

The following describes how to create an application server from the NAVER Cloud Platform console.

1. From the Classic environment of the NAVER Cloud Platform console, click the Services > Compute > Server menus, in this order.
2. Click the [Create server] button.
3. Click to select a Windows server image and click the [Next] button.
4. Enter the required information, and then click the [Next] button.
5. If you do not have an existing authentication key, then create a new authentication key and click the [Next] button.
6. If you do not have any ACG, create a new one.
7. After the final confirmation, click the [Create server] button.

Set access environment

To set up a server access environment in the Classic environment of the NAVER Cloud Platform console, you need to set up port forwarding.

Set port forwarding

The following describes how to set up port forwarding.

1. From the Classic environment of the NAVER Cloud Platform console, click the Services > Compute > Server menus, in this order.
2. Select the server to set port forwarding for, and then click the [Set port forwarding] menu.
3. Enter the external port number you want to set, and then click the [Add] button.
   • The range of available external port is 1,024 - 65,534. These external ports can only be used for the purpose of server access.
4. Click the [Apply] button.

Get admin password

After setting up port forwarding, you can get the admin (root) password required for accessing the application server through the following steps:

1. From the Classic environment of the NAVER Cloud Platform console, click the Services > Compute > Server menus, in this order.
2. Click the [Manage servers] button, and then click the Get admin password menu.
3. Enter the authentication key generated while creating the server.
4. Click the [Get password] button.
5. Check the password.

Test application server connection

You can use remote desktop connection to test if you can properly connect to the application server through the following steps:

1. Click the Start > All Programs > Accessories > Remote Desktop Connection menus, in this order.
2. Enter the public IP for server connection in Computer.
   
3. Click the [Connect] button.
4. When the user credential input pop-up window appears, enter the password you got from Get admin password.
   
5. Click the [OK] button.
6. When the Remote desktop connection warning window appears, click the [Yes] button.
   

Create MSSQL server

Some of the services provided by NAVER Cloud Platform require you to go through the subscription request procedure from the console before the start of actual usage. However, for Cloud DB for MSSQL, you can start using it upon creation of MSSQL server without a separate subscription request step. The following describes how to create an MSSQL server from the NAVER Cloud Platform console.

1. From the Classic environment of the NAVER Cloud Platform console, click the Services > Database > Cloud DB for MSSQL menus, in that order.
2. Click the DB server menu.
3. Click the [Create DB server] button.
4. When the subscription request page appears, enter the required information, and then click the [Next] button.
5. Click the [Create] button.

Set ACG

The following describes how to set up Access Control Group (ACG) for MySQL servers from the NAVER Cloud Platform console.

1. From the Classic environment of the NAVER Cloud Platform console, click the Services > Database > Cloud DB for MSSQL menus, in that order.
2. Click the ACG menu.
   
3. Click and select the ACG to set up, and then click the [Set ACG] button.
   • Select the ACG of the MSSQL server automatically created
4. Enter the ACG name of the application server in Access source.
5. Enter the port number in Allowed port.
6. Click the [Add] button.
7. Click the [Apply] button.

Test MSSQL server connection

The following describes how to test if you can connect properly to the created MSSQL server by installing the MSSQL client.

1. Check the DNS name, DB access port, account ID, and password information for the MSSQL server access.
   • Click the Services > Database > Cloud DB for MSSQL > DB server menu.
   • Click the MSSQL server's service name to access, and check the following.
     • DNS name: Check DB private domain.
     • DB access port: Check DB access port.
   • Check the account ID and password from [Manage DB] > Manage DB user.
2. Access the application server, Download SSMS, and install it.
3. Connect to SSMS.
4. Enter the DB server information in the server connection pop-up window.
   
   • Server type: Database engine
   • Server name: DNS name, DB access port (separated with comma)
     • DNS name: private domain of the MSSQL server to access
     • DB access port: access port of the MSSQL server to access
   • Authentication: SQL server authentication
   • Login: account name of the user for the MSSQL server to access
   • Password: account password of the user for the MSSQL server to access
5. Click the [Connect] button.