Using MSSQL server images

Available in Classic and VPC

About MSSQL Installer

This page describes the concept and basic structure of NAVER Cloud Platform MSSQL Installer.
"MSSQL" uses SQL Server, a relational database (RDBMS) developed by Microsoft.

About NCLOUD MSSQL

MSSQL is Microsoft's relational database service application, and MSSQL Installer provided by NAVER Cloud Platform supports pre-installed images at the default installation level.

Access Management Console

The Management Console is a server management tool in NAVER Cloud Platform that allows you to create and delete servers.

① To access the Management Console to create or delete servers, click Console on the "NAVER Cloud Platform".

Create server with MSSQL installed

Create server

This page describes how to create MSSQL pre-installed images.

Step 1. Create server

① Click [Services].

② Click [Server].

③ Click [Create server].

Step 2. Select the server image

① Select the boot disk size "100GB", image type "DBMS", and DBMS image type "MSSQL" respectively.

② Click [Next] on the right side of mssql (2016std) -win-2012-64-R2-en.

Step 3. Set server

① Set the server type.

② Enter the server name. (The server name can consist of lowercase letters and numbers.)

③ Click [Next].

Step 4. Set authentication key

In this step, you can create a new authentication key or use an existing one.

① If it’s your first time, select Create a new authentication key and enter an authentication key name.

• In our example, we entered an authentication key called mssqlncloudkey.

② Click [Create & save auth key] and save it in a safe place.

• Save the downloaded mssqlncloudkey.pem file in a safe location. This file is used to create passwords for future servers. Even if you use the same pem file, a different password will be generated for each server. (Even if the server uses the same pem file, you must upload each pem file respectively to recreate the password.)

• Key file properties stored in my computer
  

③ Click [Next].

Step 5. Set firewall

In the firewall settings, create an ACG (Access Control Group) or select an ACG you have.

① If this is your first time creating, select Create a new ACG.

• Click [Create ACG].

② Enter a suitable name. We entered allopen.

③ Field

• Protocol: Select the protocol to allow.

• Access source: Write the IP or band that you are trying to access. For example, enter 10.64.51.205 for a single IP and 10.64.51.0/24 for all accesses in the 10.64.51.XXX band. If the internal Private IP goes out via NAT, you must enter Public IP. If you want to open all bands, enter 0.0.0.0/0.

• Allowed port (service): If you want to open ports individually, enter the required port number into the Allowed port (service) and click [Add]. If more than several ports are required, add a line to enter. To open all ports, enter 1-65535. However, in this case, the server becomes vulnerable. In the example, we entered 1-65535.

④ Click [Add].

⑤ Click [Create].

Step 6. Confirm

After going through the steps above, the pem key file should be kept in a safe place on my computer and the ACG settings should be correct. Please note that you cannot access the server you created if you do not have a pem key file.

① Click [Create server].

② Wait for the server to be created.

Get server password

① Select the server you want.

② Right-click and click [Get admin password].

③ Drag or click the file to upload the mssqlncloudkey.pem file stored on my computer.

④ Click [Get admin password].

⑤ It shows the admin password provided at the time of initial creation. (You can access using the above password when you log on for the first time, and change the password on the server for future management.)

Port forwarding for remote desktop access (MSTSC)

① Select a server in the Server menu.

② Right-click on the server or click [Set Port Forwarding] at the top.

③ Enter the appropriate external port.

• It is used only for remote desktop login, and should not be duplicated.
• When accessing the server using MSTSC, access to 49.236.160.47:13389 will automatically connect to the created server 10.39.6.36:3389 (MSTSC default port) in the NAVER Cloud Platform. (The setting for the service will be described in the Public IP Setting section.)

④ Click [Add].

⑤ Click [Apply].

Access MSTSC

1. Execute MSTSC in Startup and access to the port forwarding address set above.
   

2. Click [Connect].
   

3. Enter the password you created using the Pem file.

4. Click [OK].
   

5. Click [Yes].
   

6. Logon to the server is successful.

Troubleshooting

If you cannot access the server, check the following.

1. Do you have a PEM file?
2. Is the ACG set correctly?
3. Is the port forwarding set correctly?

PEM file

If you do not have a PEM file, you need to create it again from the beginning. This is because the PEM file can be saved at the first time the server is created.

View ACG

① Select a server.

② Click the pop-up menu next to the ACG label. Currently, the allopen rule is applied.

③ You can also check through the ACG menu in the left sidebar.

④ Expand the applied rule.

⑤ Check the applied server.

⑥ Click [View rules] to check the detailed settings for the ACG.

⑦ If you need to change the ACG rule, use a [Set ACG] or [Delete ACG] menu appropriately.

Set port forwarding

① Click the Server menu.

② Check the target server.

③ Check the number next to the external port (13389).

④ If there is no number, set it through the [Set port forwarding] menu.

• In the above configuration, the sql2016seqa server can be accessed at 49.236.160.47:13389 to remotely access MSTSC from outside the NAVER Cloud Platform.

External server access using SQL authentication

This page describes how to access NAVER Cloud Platform MSSQL using public IP configuration and SQL authentication.

Set public IP

To access the server created above from external network, public IP setting is required.

① From the menu, click [Public IP].

② Click [Allocated New IP].

③ Select the created server from the Select server drop-down list.

④ Click [Next].

⑤ Check the server name and click [Create].

⑥ After a few minutes, an IP address is assigned.

When a normal public IP is assigned, access MSTSC via 49.236.160.54:3389 to connect to the server. If you are assigned a Public IP, the default port is 3389 regardless of the port forwarding you set above.

Set SQL Server SQL authentication

Execute SSMS

① Click the Windows PowerShell icon.

② Execute ssms.

③ Click [Connect].

Set SQL authentication mode

① Right-click the SQL instance.

② Click [Properties].

③ Click [Security] in Select a page.

④ Select SQL Server and Windows Authentication mode under Server authentication.

⑤ Click [OK].

Restart MSSQL service

① Right-click the SQL instance.

② Click [Restart] and select Yes from the confirmation popup.

Create SQL security authentication account

① Right-click on the SSMS Security Logins and click [New Login].

② Enter the ID to use (sqlsa), select SQL Server authentication, enter the password, and uncheck the Enforce password policy below.

③ Click [Server Roles].

④ Check "sysadmin." (Set the appropriate permissions for the service.)

⑤ Click [OK].

Connect to DB server via SQL authentication mode using SSMS

① Before connecting from external network, verify if SQL authentication is successful internally by selecting File > New > Database Engine Query.

② Enter the exact information you created above.

③ Click [Connect].

④ If successful, enter "select @@version" and click [Execute].

If everything is done properly, you can login normally from external network. (The screen below is accessed by sql2016seqa from another computer.)