createmssqldbinstance (Release 9.2.2)

API Name

createmssqldbinstance

Description

Creates an MS SQL DB instance.

REST Methods

POST

Precondition

Agent must be running.

Input Params

instanceName, componentName, agentHostName.

Sample Request

{"instanceName":"mssql_win1", "agentHostName": "jdesma.example.com", "targetType": "mssqldb", "jdeHome":"C:\\jde_sqldb_agent\\SCFHA", "componentName": "E1_SQLDB_9.2.1.4_2017-07-28_17-22.jar", "mssqldbInstance": { "mssqlDBHost":"jderest\\jderest", "mssqlDBInstallDir":"C:\ \jde921", "mssqlDBDataDir":"C:\\jde921\\Data", "mssqlDBLogDir": "C:\\jde921\\Log", "mssqlDBPort":"", "mssqlDBPass":"Tools123", "mssqlDBJdePass":", "mssqlSHARED": true, "mssqlRTE":false, "mssqldbSchema":{ "mssqlPROD":false, "mssqlPRIST":false, "mssqlCRP": false, "mssqlDEV":false }, "mssqldbDemoSchema":{ "mssqlPRODDEMO":false, "mssqlPRISTDEMO":false, "mssqlCRPDEMO": false, "mssqlDEVDEMO":false } }}

Return

HTTP status CREATED code is returned.

Sample Response

Exception

HTTP conflict if an instance with the same name exists.