Accessing DB server from outside cloud
    • PDF

    Accessing DB server from outside cloud

    • PDF

    Article Summary

    Available in VPC

    You can use the SQL Server Management Studio (SSMS) which is an MSSQL client, to access an MSSQL server from outside of NAVER Cloud Platform, and perform various tasks related to DB conveniently in the GUI-based client.

    Access through MSSQL SSMS

    You can use SSMS, an MSSQL client, to access the MSSQL server from outside of NAVER Cloud Platform and perform tasks. To access an MSSQL server using SSMS, you need to first set NAVER Cloud SSL VPN or MSSQL server's public domain.

    Access using SSL VPN

    You can request subscription to the NAVER Cloud's SSL VPN, and set it to access the server using SSMS. SSL VPN is a service that provides a private network where the access is protected through SSL encryption. It sets routing and ACG to limit access only for the allowed users, which enables more secure server access and usage.

    The following describes how to access an MSSQL server using SSMS after setting up SSL VPN.

    Caution

    Additional fees apply when you request subscription to SSL VPN. For an introduction on SSL VPN and description of the pricing plans, refer to the Services > Security > SSL VPN menu in the NAVER Cloud Platform portal.

    1. Complete product subscription request and settings by referring to SSL VPN guide, and then access SSL VPN.
    2. From the VPC environment of the NAVER Cloud Platform console, click the Services > Database > Cloud DB for MSSQL menus, in that order.
    3. Click the DB server menu.
    4. Select the MSSQL server you want to access, and set the ACG by referring to Set ACG.
      • Access source: SSL VPN's IP pool
      • Allowed port (service): access port of the MSSQL server to access
    5. Click the Manage DB > Manage DB user menus in that order, and check the user to access through SSL VPN.
    6. Download SSMS, and then install it according to the guide.
    7. Run SSMS, and then create a new MSSQL connection as shown below.
      clouddbformssql-ssms_01_vpc_en
      • 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
    8. Click the [Connect] button for connect to the MSSQL server.
    9. Refer to the guide document to use.

    Access using public domain

    You can set a public domain to an MSSQL server, and access the server using MSSQL Workbench.

    The following describes how to access an MSSQL server using SSMS after setting up a public domain.

    Caution

    The data communicated from the outside through the public domain is charged based on network usage.

    1. From the VPC 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. Select the MSSQL server you want to set a public domain for, click the Manage DB > Manage public domain menus in order, and then click the [Yes] button from the settings pop-up window.
    4. Set up ACG for the MSSQL server selected by referring to Set ACG.
    5. Click the Manage DB > Manage DB user menus in that order, and check the user that will access using the public domain.
    6. Download SSMS, and then install it according to the guide.
    7. Run SSMS, and then create a new MSSQL connection as shown below.
      clouddbformssql-ssms_01_vpc_en
      • Server type: Database engine
      • Server name: DNS name, DB access port (separated with comma)
        • DNS name: public 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
    8. Click the [Connect] button for connect to the MSSQL server.
    9. Refer to the guide document to use.
    Caution
    • Note that if you make changes to a DB account through SSMS, use of some features will become restricted on the console.

    • If you create user (account) or change password directly on SSMS, the changes to permissions and password won't be replicated in the duplexed mirror server, which may lead to problems in case of failover.

    • If you create a database directly on SSMS, you must select the full recovery model option to enable the mirroring configuration.


    Was this article helpful?

    Changing your password will log you out immediately. Use the new password to log back in.
    First name must have atleast 2 characters. Numbers and special characters are not allowed.
    Last name must have atleast 1 characters. Numbers and special characters are not allowed.
    Enter a valid email
    Enter a valid password
    Your profile has been successfully updated.