createCloudMssqlInstance

Article summary

Did you find this summary helpful?

Thank you for your feedback

Available in VPC

Create a Cloud DB for MSSQL instance.

Request

The following describes the request format for the endpoint. The request format is as follows:

Method	URI
GET, POST	/createCloudMssqlInstance

Request headers

For headers common to all Cloud DB for MSSQL (VPC) APIs, see Cloud DB for MSSQL (VPC) request headers.

Request parameter

The following describes the parameters.

Field	Type	Required	Description
`regionCode`	String	Optional	Region code of the Cloud DB for MSSQL instance to create Check through getRegionList First Region of the `getRegionList` query result (default)
`vpcNo`	String	Required	Number of VPC to create the Cloud DB for MSSQL instance in Check through getCloudMssqlTargetVpcList
`subnetNo`	String	Required	Subnet number of the default network interface to be used in the Cloud DB for MSSQL instance Check through getCloudMssqlTargetSubnetList Subscription to public domains can only be done in a DB server created in public subnet Subnet migrations are not available after creating the Cloud DB for MSSQL instance
`mirrorSubnetNo`	String	Conditional	Subnet number of the mirror server Must be entered for multi-zone CloudDB for MSSQL Check through getCloudMssqlTargetSubnetList It must be in a different zone from the principal server's subnet, but the public or private status must match
`cloudMssqlServiceName`	String	Required	Name of the Cloud DB for MSSQL service to create 3 to 15 characters, including English letters, Korean letters, numbers, and special character "-"
`configGroupNo`	String	Optional	Cloud DB for MSSQL config group number A config group created in advance can be applied when you create a server If you don't have your own config group, you can choose from the config groups provided by default Check through getCloudMssqlConfigGroupList 0 (default)
`cloudMssqlImageProductCode`	String	Optional	Cloud DB for MSSQL image product code Check through getCloudMssqlImageProductList Automatically generated by NAVER Cloud Platform (default)
`cloudMssqlProductCode`	String	Optional	Cloud DB for MSSQL product code Determine the server specification for the Cloud DB for MSSQL instance to create Check through getCloudMssqlProductList Minimum specification (default) Minimum specification is based on 1. memory and 2. CPU
`dataStorageTypeCode`	String	Optional	Data storage type code The data storage type can't be changed after installation `SSD` (default) \| `HDD`
`isHa`	Boolean	Required	High availability status Selecting `true` (high availability) creates two servers, including a standby master server, and incurs additional fees If `false`, `isMultiZone` and `mirrorSubnetNo` parameters are not used
`isMultiZone`	Boolean	Optional	Multi-zone status `true` \| `false` (default) Can only be entered if the high availability status (`isHa`) is `true` If `true`, provide the principal and mirror servers in separate zones to provide higher availability
`backupFileRetentionPeriod`	Integer	Optional	Backup file retention period (days) 1 - 30 (default: 1) Backup is performed every day, and the backup file is stored in a separate backup storage Fees are charged for the space you use
`backupTime`	String	Conditional	Set backup time (HH:MM) Required if the automatic backup status (`isAutomaticBackup`) is `false` Enter in 15 minute increments <E.g.> 01:15
`isAutomaticBackup`	Boolean	Optional	Whether to set the backup time automatically `true` (default) \| `false` If `true`, the backup time is set automatically regardless of `backupTime`
`cloudMssqlUserName`	String	Required	DB user account ID 4 to 16 characters, including English letters, numbers, and special character "_", and must begin with an English letter
`cloudMssqlUserPassword`	String	Required	DB user account password Enter between 8 and 20 characters containing at least one English letter, number, and special character Special characters ` " ' \ / & and spaces can't be used
`cloudMssqlPort`	Integer	Optional	TCP port number to access the Cloud DB for MSSQL instance `1433` (default) Specified range: 10000 - 20000
`characterSetName`	String	Optional	DB character set Check through getCloudMssqlCharacterSetList Select between Korean and English collation `Korean_Wansung_CI_AS` (default) \| `SQL_Latin1_General_CP1_CI_AS` `Korean_Wansung_CI_AS`: Korean perfect form `SQL_Latin1_General_CP1_CI_AS`: English version
`responseFormatType`	String	Optional	Format of the response result `xml` (default) \| `json`

Request example

The following is a sample request.

curl --location --request GET 'https://ncloud.apigw.ntruss.com/vmssql/v2/createCloudMssqlInstance
?regionCode=KR
&vpcNo=59***
&subnetNo=140***
&mirrorSubnetNo=158***
&cloudMssqlServiceName=mssql003
&configGroupNo=***
&cloudMssqlImageProductCode=SW.VMSSL.OS.WND64.WINNT.SVR2016.MSSQL.15043553.EE.B100
&cloudMssqlProductCode=SVR.VMSSL.HICPU.C002.M004.NET.HDD.B100.G002
&dataStorageTypeCode=SSD
&isHa=true
&isMultiZone=true
&backupFileRetentionPeriod=1
&backupTime=10:15
&isAutomaticBackup=false
&cloudMssqlUserName=user000
&cloudMssqlUserPassword=*********
&cloudMssqlPort=1433
&characterSetName=Korean_Wansung_CI_AS
&responseFormatType=json'
--header 'x-ncp-apigw-timestamp: {Timestamp}'
--header 'x-ncp-iam-access-key: {Access Key}'
--header 'x-ncp-apigw-signature-v2: {API Gateway Signature}'

Response

The following describes the response format.

Response body

See CloudMssqlInstanceList for the response body.

Response status codes

For response status codes common to NAVER Cloud Platform, see Ncloud API response status codes.

Response example

The following is a sample response.

If responseFormetType=json

{
    "createCloudMssqlInstanceResponse": {
        "totalRows": 1,
        "cloudMssqlInstanceList": [
                {
                    "cloudMssqlInstanceNo": "2528****",
                    "cloudMssqlServiceName": "mssql003",
                    "cloudMssqlInstanceStatusName": "creating",
                "cloudMssqlInstanceStatus": {
                    "code": "INIT",
                    "codeName": "CLOUD DATABASE(VPC) Init State"
                },
                "cloudMssqlInstanceOperation": {
                    "code": "CREAT",
                    "codeName": "CLOUD DATABASE(VPC) Creat OP"
                },
                "cloudMssqlImageProductCode": "SW.VMSSL.OS.WND64.WINNT.SVR2016.MSSQL.15043553.EE.B100",
                "isHa": true,
                "isMultiZone": true,
                "license": {
                    "code": "SPLA",
                    "codeName": "Service Provider License Agreement"
                },
                "cloudMssqlPort": 1433,
                "backupFileRetentionPeriod": 1,
                "backupTime": "10:15",
                "configGroupNo": "***",
                "configGroupName": "mssql_2019_default",
                "engineVersion": "MSSQL 15.0.4355.3 Enterprise Edition",
                "createDate": "2024-07-01T11:34:11+0900",
                "dbCollation": "Korean_Wansung_CI_AS",
                "cloudMssqlServerInstanceList": [
                    {
                        "cloudMssqlServerName": "m-2528****-001",
                        "cloudMssqlServerRole": {
                            "code": "M",
                            "codeName": "Principal"
                        },
                        "cloudMssqlServerInstanceStatusName": "creating",
                        "cloudMssqlServerInstanceStatus": {
                            "code": "PEND",
                            "codeName": "CLOUD DATABASE(VPC) Server Pending State"
                        },
                        "cloudMssqlServerInstanceOperation": {
                            "code": "CREAT",
                            "codeName": "CLOUD DATABASE(VPC) Server Create OP"
                        },
                        "regionCode": "KR",
                        "zoneCode": "KR-1",
                        "vpcNo": "59***",
                        "subnetNo": "140***",
                        "dataStorageSize": 107374182400,
                        "cpuCount": 2,
                        "memorySize": 4294967296,
                        "isPublicSubnet": true,
                        "cloudMssqlProductCode": "SVR.VMSSL.HICPU.C002.M004.NET.HDD.B100.G002",
                        "createDate": "2024-07-01T11:34:11+0900",
                        "dataStorageType": {
                            "code": "SSD",
                            "codeName": "SSD"
                        }
                    },
                    {
                        "cloudMssqlServerName": "m-2528****-002",
                        "cloudMssqlServerRole": {
                            "code": "H",
                            "codeName": "Mirror"
                        },
                        "cloudMssqlServerInstanceStatusName": "creating",
                        "cloudMssqlServerInstanceStatus": {
                            "code": "PEND",
                            "codeName": "CLOUD DATABASE(VPC) Server Pending State"
                        },
                        "cloudMssqlServerInstanceOperation": {
                            "code": "CREAT",
                            "codeName": "CLOUD DATABASE(VPC) Server Create OP"
                        },
                        "regionCode": "KR",
                        "zoneCode": "KR-2",
                        "vpcNo": "59***",
                        "subnetNo": "158***",
                        "dataStorageSize": 107374182400,
                        "cpuCount": 2,
                        "memorySize": 4294967296,
                        "isPublicSubnet": true,
                        "cloudMssqlProductCode": "SVR.VMSSL.HICPU.C002.M004.NET.HDD.B100.G002",
                        "createDate": "2024-07-01T11:34:11+0900",
                        "dataStorageType": {
                            "code": "SSD",
                            "codeName": "SSD"
                        }
                    }
                ]
            }
        ],
        "requestId": "7e05dba1-****-****-****-e463eb447507",
        "returnCode": "0",
        "returnMessage": "success"
    }
}

If responseFormetType=xml (default)

<?xml version="1.0" encoding="UTF-8"?>
<createCloudMssqlInstanceResponse>
    <requestId>7e05dba1-****-****-****-e463eb447507</requestId>
    <returnCode>0</returnCode>
    <returnMessage>success</returnMessage>
    <totalRows>1</totalRows>
    <cloudMssqlInstanceList>
        <cloudMssqlInstance>
            <cloudMssqlInstanceNo>2528****</cloudMssqlInstanceNo>
            <cloudMssqlServiceName>mssql003</cloudMssqlServiceName>
            <cloudMssqlInstanceStatusName>creating</cloudMssqlInstanceStatusName>
            <cloudMssqlInstanceStatus>
                <code>INIT</code>
                <codeName>CLOUD DATABASE(VPC) Init State</codeName>
            </cloudMssqlInstanceStatus>
            <cloudMssqlInstanceOperation>
                <code>CREAT</code>
                <codeName>CLOUD DATABASE(VPC) Creat OP</codeName>
            </cloudMssqlInstanceOperation>
            <cloudMssqlImageProductCode>SW.VMSSL.OS.WND64.WINNT.SVR2016.MSSQL.15043553.EE.B100</cloudMssqlImageProductCode>
            <isHa>true</isHa>
            <isMultiZone>true</isMultiZone>
            <license>
                <code>SPLA</code>
                <codeName>Service Provider License Agreement</codeName>
            </license>
            <cloudMssqlPort>1433</cloudMssqlPort>
            <backupFileRetentionPeriod>1</backupFileRetentionPeriod>
            <backupTime>10:15</backupTime>
            <configGroupNo>***</configGroupNo>
            <configGroupName>mssql_2019_default</configGroupName>
            <engineVersion>MSSQL 15.0.4355.3 Enterprise Edition</engineVersion>
            <createDate>2024-07-01T11:34:11+0900</createDate>
            <dbCollation>Korean_Wansung_CI_AS</dbCollation>
            <cloudMssqlServerInstanceList>
                <cloudMssqlServerInstance>
                    <cloudMssqlServerName>m-2528****-001</cloudMssqlServerName>
                    <cloudMssqlServerRole>
                        <code>M</code>
                        <codeName>Principal</codeName>
                    </cloudMssqlServerRole>
                    <cloudMssqlServerInstanceStatusName>creating</cloudMssqlServerInstanceStatusName>
                    <cloudMssqlServerInstanceStatus>
                        <code>PEND</code>
                        <codeName>CLOUD DATABASE(VPC) Server Pending State</codeName>
                    </cloudMssqlServerInstanceStatus>
                    <cloudMssqlServerInstanceOperation>
                        <code>CREAT</code>
                        <codeName>CLOUD DATABASE(VPC) Server Create OP</codeName>
                    </cloudMssqlServerInstanceOperation>
                    <regionCode>KR</regionCode>
                    <zoneCode>KR-1</zoneCode>
                    <vpcNo>59***</vpcNo>
                    <subnetNo>140***</subnetNo>
                    <dataStorageSize>107374182400</dataStorageSize>
                    <cpuCount>2</cpuCount>
                    <memorySize>4294967296</memorySize>
                    <isPublicSubnet>true</isPublicSubnet>
                    <cloudMssqlProductCode>SVR.VMSSL.HICPU.C002.M004.NET.HDD.B100.G002</cloudMssqlProductCode>
                    <createDate>2024-07-01T11:34:11+0900</createDate>
                    <dataStorageType>
                        <code>SSD</code>
                        <codeName>SSD</codeName>
                    </dataStorageType>
                </cloudMssqlServerInstance>
                <cloudMssqlServerInstance>
                    <cloudMssqlServerName>m-2528****-002</cloudMssqlServerName>
                    <cloudMssqlServerRole>
                        <code>H</code>
                        <codeName>Mirror</codeName>
                    </cloudMssqlServerRole>
                    <cloudMssqlServerInstanceStatusName>creating</cloudMssqlServerInstanceStatusName>
                    <cloudMssqlServerInstanceStatus>
                        <code>PEND</code>
                        <codeName>CLOUD DATABASE(VPC) Server Pending State</codeName>
                    </cloudMssqlServerInstanceStatus>
                    <cloudMssqlServerInstanceOperation>
                        <code>CREAT</code>
                        <codeName>CLOUD DATABASE(VPC) Server Create OP</codeName>
                    </cloudMssqlServerInstanceOperation>
                    <regionCode>KR</regionCode>
                    <zoneCode>KR-2</zoneCode>
                    <vpcNo>59***</vpcNo>
                    <subnetNo>158***</subnetNo>
                    <dataStorageSize>107374182400</dataStorageSize>
                    <cpuCount>2</cpuCount>
                    <memorySize>4294967296</memorySize>
                    <isPublicSubnet>true</isPublicSubnet>
                    <cloudMssqlProductCode>SVR.VMSSL.HICPU.C002.M004.NET.HDD.B100.G002</cloudMssqlProductCode>
                    <createDate>2024-07-01T11:34:11+0900</createDate>
                    <dataStorageType>
                        <code>SSD</code>
                        <codeName>SSD</codeName>
                    </dataStorageType>
                </cloudMssqlServerInstance>
            </cloudMssqlServerInstanceList>
        </cloudMssqlInstance>
    </cloudMssqlInstanceList>
</createCloudMssqlInstanceResponse>

Was this article helpful?

What's Next

createCloudMssqlSlaveInstance

Table of contents

Request
Response