Getting started with Cloud DB for MSSQL

The latest service changes have not yet been reflected in this content. We will update the content as soon as possible. Please refer to the Korean version for information on the latest updates.

Available in VPC

Getting started with Cloud DB for MSSQL describes what you need to do to properly use Cloud DB for MSSQL after checking the Cloud DB for MSSQL user environment and supported specifications and fully understanding the Overall usage scenarios 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.

• Event and notification (alarm) settings using NAVER Cloud Platform's Cloud Insight
• Management of administration permissions using NAVER Cloud Platform's Sub Account

The above tasks can be done from Cloud Insight or Sub Account after subscribing, rather than in Cloud DB for MSSQL. They are not explained in detail in this guide. For more information, see Cloud Insight user guide and Sub Account user guide.

Create application server

To create an application server from the NAVER Cloud Platform console, follow these steps:

1. From the VPC environment of the NAVER Cloud Platform console, click Services > Compute > Server, in 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 VPC environment of the NAVER Cloud Platform console, you need to set up a public IP.

Set public IP

To set up a public IP, follow these steps:

1. From the VPC environment of the NAVER Cloud Platform console, click Services > Compute > Server, in order.
2. Click the Public IP menu.
3. Click the [Request public IP] button.
4. Select the target server, enter a memo, and then click the [Next] button.
5. Click the [Create] button.

Get admin password

To get the admin (root) password required for accessing the application server after setting up the public IP, follow these steps:

1. From the VPC environment of the NAVER Cloud Platform console, click Services > Compute > Server, in order.
2. Click the [Manage servers and change settings] 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

To test if you can properly connect to the application server using a remote desktop connection, follow these steps:

1. Click Start > All Programs > Accessories > Remote Desktop Connection, in 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 ID and 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 procedure from the console before the start of actual usage. However, for Cloud DB for MSSQL, you can start using it upon creation of an MSSQL server without a separate subscribe step. To create an MSSQL server from the NAVER Cloud Platform console, follow these steps:

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

Set ACG

To set up Access Control Group (ACG) for MSSQL servers from the NAVER Cloud Platform console, follow these steps:

1. From the VPC environment of the NAVER Cloud Platform console, click Services > Database > Cloud DB for MSSQL, in 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

To test if you can connect properly to the created MSSQL server by installing the MSSQL client, follow these steps:

1. Check the DNS name, DB access port, account ID, and password information for the MSSQL server access.
   • Click Services > Database > Cloud DB for MSSQL > DB server.
   • Click the MSSQL server's service name to access, and check the following:
     • DNS name: check 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.

Data migration (backup/recovery)

In order to migrate the database operated on-premise to Cloud DB for MSSQL (CDB-MSSQL) or move it from CDB-MSSQL to on-premise, you need to create a window application server. Data migration is performed using the backup and recovery of the SQL server, and you can either proceed with it after uploading the database operated on-premise on the application server or backup the CDB-MSSQL to the application server.

1. Create application server

   • Check VPC and subnet of the CDB-MSSQL
     

   • Check VPC and Subnet of the application server
     

   • After creating the backup folder on the created application server, set sharing (Everyone, Read/Write)
     

   • Turn off the password protected sharing

     • Control Panel > Network and Internet > Network and Sharing Center > Advanced sharing settings
     • Password protected sharing option > Select Turn off password protected sharing > Apply
       

• Set ACG of the application server
  • The inbound port 445 of the application server should be open to VPC bandwidth.
    
• Set the MSSQL Server's ACG
  • The outbound port 445 of the MSSQL server must be open to the VPC range.
    

2. Backup (sample)

   backup database testdb to disk ='\\10.0.1.9\backup\testdb.bak'
   

   

3. Recovery (sample)

   • When restoring the database, you should recover it to d:\data folder. The database recovered to other directories does not guarantee stability.

   restore database testdb2 from disk ='\\10.0.1.9\backup\testdb.bak'
   with
     move 'testdb' to 'd:\data\testdb2.mdf',
     move 'testdb-log' to 'd:\data\testdb2_log.ldf'
   

   

Troubleshooting SID problems

This guide walks you through troubleshooting issues due to SID inconsistency in data migration (backup/recovery).

1. Restore by changing db_owner in the original server (ON-PREMISE → CDB-MSSQL)

2. Add db_owner to the server to be recovered (CDB-MSSQL → CDB-MSSQL)