Reference for TestSqlConnection

Url: sql/connection

HTTP Method: PUT

Message direction | Format | Body
--- | --- | ---
Request | XML | Example,Schema
Response | XML | Example,Schema

The following is an example request XML body:

    <?xml version="1.0" encoding="utf-16"?>
    <sqlCredentials xmlns="http://apprecovery.com/management/api/2010/05">
      <instancesCredentials>
        <!--Valid elements of type: virtualInstanceCredentials-->
        <instanceCredentials i:type="virtualInstanceCredentials" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
          <credentialsAccountId>1627aea5-8e0a-4371-9022-9b504344e724</credentialsAccountId>
          <encryptPassword>true</encryptPassword>
          <password>String content</password>
          <passwordEncrypted>String content</passwordEncrypted>
          <userName>String content</userName>
          <instanceName>String content</instanceName>
          <useDefaultCredentials>true</useDefaultCredentials>
          <useWindowsAuthentication>true</useWindowsAuthentication>
          <virtualServerName>String content</virtualServerName>
        </instanceCredentials>
        <!--Valid elements of type: virtualInstanceCredentials-->
        <instanceCredentials i:type="virtualInstanceCredentials" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
          <credentialsAccountId>1627aea5-8e0a-4371-9022-9b504344e724</credentialsAccountId>
          <encryptPassword>true</encryptPassword>
          <password>String content</password>
          <passwordEncrypted>String content</passwordEncrypted>
          <userName>String content</userName>
          <instanceName>String content</instanceName>
          <useDefaultCredentials>true</useDefaultCredentials>
          <useWindowsAuthentication>true</useWindowsAuthentication>
          <virtualServerName>String content</virtualServerName>
        </instanceCredentials>
      </instancesCredentials>
    </sqlCredentials>

The following is an example response XML body:

    No Xml response output for this method.

The following is the request XML Schema:

    <?xml version="1.0" encoding="utf-16"?>
    <Schemas>
      <xs:schema xmlns:tns="http://schemas.microsoft.com/2003/10/Serialization/" attributeFormDefault="qualified" elementFormDefault="qualified" targetNamespace="http://schemas.microsoft.com/2003/10/Serialization/" xmlns:xs="http://www.w3.org/2001/XMLSchema">
        <xs:element name="anyType" nillable="true" type="xs:anyType" />
        <xs:element name="anyURI" nillable="true" type="xs:anyURI" />
        <xs:element name="base64Binary" nillable="true" type="xs:base64Binary" />
        <xs:element name="boolean" nillable="true" type="xs:boolean" />
        <xs:element name="byte" nillable="true" type="xs:byte" />
        <xs:element name="dateTime" nillable="true" type="xs:dateTime" />
        <xs:element name="decimal" nillable="true" type="xs:decimal" />
        <xs:element name="double" nillable="true" type="xs:double" />
        <xs:element name="float" nillable="true" type="xs:float" />
        <xs:element name="int" nillable="true" type="xs:int" />
        <xs:element name="long" nillable="true" type="xs:long" />
        <xs:element name="QName" nillable="true" type="xs:QName" />
        <xs:element name="short" nillable="true" type="xs:short" />
        <xs:element name="string" nillable="true" type="xs:string" />
        <xs:element name="unsignedByte" nillable="true" type="xs:unsignedByte" />
        <xs:element name="unsignedInt" nillable="true" type="xs:unsignedInt" />
        <xs:element name="unsignedLong" nillable="true" type="xs:unsignedLong" />
        <xs:element name="unsignedShort" nillable="true" type="xs:unsignedShort" />
        <xs:element name="char" nillable="true" type="tns:char" />
        <xs:simpleType name="char">
          <xs:restriction base="xs:int" />
        </xs:simpleType>
        <xs:element name="duration" nillable="true" type="tns:duration" />
        <xs:simpleType name="duration">
          <xs:restriction base="xs:duration">
            <xs:pattern value="\-?P(\d*D)?(T(\d*H)?(\d*M)?(\d*(\.\d*)?S)?)?" />
            <xs:minInclusive value="-P10675199DT2H48M5.4775808S" />
            <xs:maxInclusive value="P10675199DT2H48M5.4775807S" />
          </xs:restriction>
        </xs:simpleType>
        <xs:element name="guid" nillable="true" type="tns:guid" />
        <xs:simpleType name="guid">
          <xs:restriction base="xs:string">
            <xs:pattern value="[\da-fA-F]{8}-[\da-fA-F]{4}-[\da-fA-F]{4}-[\da-fA-F]{4}-[\da-fA-F]{12}" />
          </xs:restriction>
        </xs:simpleType>
        <xs:attribute name="FactoryType" type="xs:QName" />
        <xs:attribute name="Id" type="xs:ID" />
        <xs:attribute name="Ref" type="xs:IDREF" />
      </xs:schema>
      <xs:schema xmlns:ser="http://schemas.microsoft.com/2003/10/Serialization/" xmlns:tns="http://apprecovery.com/management/api/2010/05" elementFormDefault="qualified" targetNamespace="http://apprecovery.com/management/api/2010/05" xmlns:xs="http://www.w3.org/2001/XMLSchema">
        <xs:import namespace="http://schemas.microsoft.com/2003/10/Serialization/" />
        <xs:complexType name="sqlCredentials">
          <xs:sequence>
            <xs:element minOccurs="0" name="instancesCredentials" nillable="true" type="tns:instancesCredentials" />
          </xs:sequence>
        </xs:complexType>
        <xs:element name="sqlCredentials" nillable="true" type="tns:sqlCredentials" />
        <xs:complexType name="instancesCredentials">
          <xs:sequence>
            <xs:element minOccurs="0" maxOccurs="unbounded" name="instanceCredentials" nillable="true" type="tns:instanceCredentials" />
          </xs:sequence>
        </xs:complexType>
        <xs:element name="instancesCredentials" nillable="true" type="tns:instancesCredentials" />
        <xs:complexType name="instanceCredentials">
          <xs:complexContent mixed="false">
            <xs:extension base="tns:baseCredentials">
              <xs:sequence>
                <xs:element minOccurs="0" name="instanceName" nillable="true" type="xs:string" />
                <xs:element minOccurs="0" name="useDefaultCredentials" type="xs:boolean" />
                <xs:element minOccurs="0" name="useWindowsAuthentication" type="xs:boolean" />
              </xs:sequence>
            </xs:extension>
          </xs:complexContent>
        </xs:complexType>
        <xs:element name="instanceCredentials" nillable="true" type="tns:instanceCredentials" />
        <xs:complexType name="baseCredentials">
          <xs:sequence>
            <xs:element minOccurs="0" name="credentialsAccountId" type="ser:guid" />
            <xs:element minOccurs="0" name="encryptPassword" type="xs:boolean" />
            <xs:element minOccurs="0" name="password" nillable="true" type="xs:string" />
            <xs:element minOccurs="0" name="passwordEncrypted" nillable="true" type="xs:string" />
            <xs:element minOccurs="0" name="userName" nillable="true" type="xs:string" />
          </xs:sequence>
        </xs:complexType>
        <xs:element name="baseCredentials" nillable="true" type="tns:baseCredentials" />
        <xs:complexType name="oracleInstanceCredentials">
          <xs:complexContent mixed="false">
            <xs:extension base="tns:baseCredentials">
              <xs:sequence>
                <xs:element minOccurs="0" name="hostName" nillable="true" type="xs:string" />
                <xs:element minOccurs="0" name="instanceServiceName" nillable="true" type="xs:string" />
                <xs:element minOccurs="0" name="instanceSid" nillable="true" type="xs:string" />
                <xs:element minOccurs="0" name="port" type="xs:int" />
                <xs:element minOccurs="0" name="tnsNetworkAlias" nillable="true" type="xs:string" />
                <xs:element minOccurs="0" name="useWindowsAuthentication" type="xs:boolean" />
              </xs:sequence>
            </xs:extension>
          </xs:complexContent>
        </xs:complexType>
        <xs:element name="oracleInstanceCredentials" nillable="true" type="tns:oracleInstanceCredentials" />
        <xs:complexType name="virtualInstanceCredentials">
          <xs:complexContent mixed="false">
            <xs:extension base="tns:instanceCredentials">
              <xs:sequence>
                <xs:element minOccurs="0" name="virtualServerName" nillable="true" type="xs:string" />
              </xs:sequence>
            </xs:extension>
          </xs:complexContent>
        </xs:complexType>
        <xs:element name="virtualInstanceCredentials" nillable="true" type="tns:virtualInstanceCredentials" />
      </xs:schema>
    </Schemas>

The following is the response XML Schema:

    The response body is empty.