Getting started

Available in Classic

Getting started explains the tasks you must perform to use Cloud DB for MSSQL properly after reviewing the usage environment and supported specifications and becoming familiar with the overall quickstart and glossary. Getting started covers the following topics:

• How to create an application server in the NAVER Cloud Platform console.
• How to test access to the application server.
• How to create a MSSQL Server in the NAVER Cloud Platform console.
• How to test access to the MSSQL Server.

Once you complete these steps, you have finished the basic process required to use Cloud DB for MSSQL. Afterward, you can perform the following tasks for more efficient server management and operation.

• Operational permissions management using Sub Account in the NAVER Cloud Platform.

You can perform these tasks after requesting access to Sub Account, not Cloud DB for MSSQL, and this guide does not describe them in detail. For detailed usage instructions, see the Sub Account user guide.

Create an application server

To create an application server in the NAVER Cloud Platform console:

1. Access the NAVER Cloud Platform console.
2. Click Region & Platform at the upper right of the console interface.
3. Select the Region in use and the Classic platform, and then click [Apply].
4. At the upper left of the console interface, Click the icon.
5. Navigate to Services > Compute > Server.
6. Click [Create Server].
7. Select a Windows server image and click [Next].
8. Enter the required information and click [Next].
9. If you do not have an authentication key, create a new one and click [Next].
10. If you do not have an ACG, create a new ACG.
11. After completing the final review, click [Create Server].

Configure the connection environment

To configure the server connection environment in the Classic environment of the NAVER Cloud Platform console, you must configure port forwarding.

Configure port forwarding

To configure port forwarding:

1. In the Classic environment of the NAVER Cloud Platform console, navigate to > Services > Compute > Server.
2. Select the server for which you want to configure port forwarding, and then click [Configure port forwarding] .
3. Enter the external port number to configure and click [Add].
   • The available external port range is 1,024–65,534. This external port can be used only for server access.
4. Click [Apply].

Administrator password check

To check the administrator (root) password required to access the application server, after configuring port forwarding:

1. In the Classic environment of the NAVER Cloud Platform console, navigate to > Services > Compute > Server.
2. Click [Server Management and Settings], and then click the Check Administrator Password menu.
3. Enter the authentication key created when you created the server.
4. Click [Check Password].
5. Check the password.

Test the application server connection

To test whether you can successfully connect to the application server using Remote Desktop Connection:

1. Navigate to Start > All Programs > Accessories > Remote Desktop Connection.
2. Enter the public IP address for server access in the Computer field.
   
3. Click [Connect].
4. When the user credentials popup appears, enter the ID and password obtained from the administrator password check.
   
5. Click [OK].
6. When the Remote Desktop Connection warning window appears, click [Yes (Y)].
   

MSSQL Server creation

Some services provided by the NAVER Cloud Platform require a usage request process in the console before you can begin actual use. However, Cloud DB for MSSQL starts being used as soon as you create an MSSQL server, without a separate service subscription step. To create a MSSQL Server in the NAVER Cloud Platform console:

1. In the Classic environment of the NAVER Cloud Platform console, navigate to Services > Database > Cloud DB for MSSQL.
2. Click the DB Server menu.
3. Click [Create DB Server].
4. When the service subscription interface appears, enter the required information and click [Next] .
5. Click [Create].

Configure the ACG

To configure the ACG (Access Control Group) for a MySQL server in the NAVER Cloud Platform console:

1. In the Classic environment of the NAVER Cloud Platform console, navigate to Services > Database > Cloud DB for MSSQL.
2. Click ACG.
   
3. Select the ACG you want to configure, and then click [Configure ACG].
   • Select the automatically created MSSQL Server ACG.
4. In Access source, enter the application server ACG name.
5. In Allowed port, enter the port number.
6. Click [Add].
7. Click [Apply].

MSSQL Server connection test

To test whether you can successfully connect to the created MSSQL server by installing an MSSQL client:

1. Check the DNS name, DB connection port, account ID, and password required to connect to the MSSQL server.
   • Navigate to Services > Database > Cloud DB for MSSQL > DB Server.
   • Click the service name of the MSSQL server to connect to, and then check the following items.
     • DNS name: Check the private domain.
     • DB connection port: Check the DB connection port.
   • In [DB management] > DB User management , check the account ID and password.
2. After connecting to the application server, download SQL Server Management Studio (SSMS) to install it.
3. Access SSMS.
4. Enter the DB server information in the Connect to Server popup.
   
   • Server type: Database Engine
   • Server name: DNS name and DB connection port (separated by a comma)
     • DNS name: The private domain of the MSSQL server to connect to
     • DB connection port: The connection port of the MSSQL server to connect to
   • Certificate: SQL server certificate
   • Login: The user account name of the MSSQL server to connect to
   • Password: The user account password of the MSSQL server to connect to
5. Click [Connect].