API Name: createMssqlDb
Description: This api will create a MSSQL database.
Method: HTTP POST/GET
API URL: https://resellerapi.HostBuddy.com/createMssqlDb
Parameters:
| Parameter_Name |
Type |
Length |
Description |
| apiid |
string |
9 |
This is your api id |
| apikey |
guid |
48 |
This is your api key |
| loginid |
string |
2 to 255 |
This is the hosting account login-id. Ex: memberid-001 , memberid-002 and etc.... |
| dbname |
string |
8 to 16 |
Name of the database you would like to create |
| dbloginpwd |
string |
8 to 16 |
Password of the database |
| dbtype |
string |
3 Types Only |
MSSQL2012, MSSQL2014, MSSQL2016 |
| dbspace |
int |
|
Number of MB you would like to assign to your db. Ex: 1000 = 1000MB. |
Return
This function will return db info after creation OR error message.
{"result": {"status" : "true/false", "code" : "response_code", "response_message" : "message" , "dbinfo" : "{"dbname":"name of database", "dbloginid":"databases login id", "dbserver":"the sql server name" , "refid","the reference id of the sql database"}"}}
Error Code
G1000="Invalid Reseller Account/Authentication Error"
G1001="Invalid Hosting Account/Account Doesn't Belong To This Reseller"
G2000= [this is a general invalid parameter message]
G2001= [this is for other general error message]
S1001="Invalid DB Name or DB Server" Article ID: 1680, Created: July 2, 2014 at 6:56 PM, Modified: January 4, 2017 at 4:46 AM