{"resource_type":{"id":132,"name":"ms_sql_server","schema":"{\n\t\"$schema\": \"https://json-schema.org/draft/2020-12/schema\",\n\t\"order\": [\n\t\t\"host\",\n\t\t\"user\",\n\t\t\"password\",\n\t\t\"integrated_auth\",\n\t\t\"aad_token\",\n\t\t\"port\",\n\t\t\"dbname\",\n\t\t\"instance_name\",\n\t\t\"trust_cert\",\n\t\t\"ca_cert\",\n\t\t\"encrypt\"\n\t],\n\t\"properties\": {\n\t\t\"aad_token\": {\n\t\t\t\"description\": \"AAD token for authentication\",\n\t\t\t\"format\": \"resource-azure_oauth\",\n\t\t\t\"nullable\": true,\n\t\t\t\"type\": \"object\"\n\t\t},\n\t\t\"ca_cert\": {\n\t\t\t\"default\": \"\",\n\t\t\t\"description\": \"CA certificate in PEM format for verifying the server identity. Only needed if the certificate used by the server is not in the workers's trust store.\",\n\t\t\t\"pattern\": \"^(-----BEGIN CERTIFICATE-----\\\\s+([A-Za-z0-9+/=\\\\s]+?)-----END CERTIFICATE-----)?$\",\n\t\t\t\"type\": \"string\"\n\t\t},\n\t\t\"dbname\": {\n\t\t\t\"default\": \"\",\n\t\t\t\"description\": \"\",\n\t\t\t\"type\": \"string\"\n\t\t},\n\t\t\"encrypt\": {\n\t\t\t\"default\": true,\n\t\t\t\"description\": \"Enable TLS encryption. When false, all data including passwords are sent unencrypted over the network. Set to false only for local development.\",\n\t\t\t\"type\": \"boolean\"\n\t\t},\n\t\t\"host\": {\n\t\t\t\"default\": \"\",\n\t\t\t\"description\": \"\",\n\t\t\t\"type\": \"string\"\n\t\t},\n\t\t\"instance_name\": {\n\t\t\t\"default\": \"\",\n\t\t\t\"description\": \"\",\n\t\t\t\"type\": \"string\"\n\t\t},\n\t\t\"integrated_auth\": {\n\t\t\t\"default\": false,\n\t\t\t\"description\": \"Use Windows Integrated Authentication (Kerberos). When enabled, the worker's service account credentials are used instead of username/password. Requires the worker to have a valid Kerberos ticket.\",\n\t\t\t\"type\": \"boolean\"\n\t\t},\n\t\t\"password\": {\n\t\t\t\"default\": \"\",\n\t\t\t\"description\": \"\",\n\t\t\t\"type\": \"string\"\n\t\t},\n\t\t\"port\": {\n\t\t\t\"description\": \"\",\n\t\t\t\"type\": \"number\"\n\t\t},\n\t\t\"trust_cert\": {\n\t\t\t\"default\": true,\n\t\t\t\"description\": \"Trust any certificate presented by the server\",\n\t\t\t\"type\": \"boolean\"\n\t\t},\n\t\t\"user\": {\n\t\t\t\"default\": \"\",\n\t\t\t\"description\": \"\",\n\t\t\t\"type\": \"string\"\n\t\t}\n\t},\n\t\"required\": [\n\t\t\"host\",\n\t\t\"dbname\"\n\t],\n\t\"type\": \"object\"\n}","approved":true,"app":"ms_sql_server","description":"Microsoft SQL Server resource. Supports username/password, AAD token, or Windows Integrated Authentication.","created_by":"hugo697","created_at":"2023-11-10T09:58:45.099Z"}}