Skip to content

Commit b338e56

Browse files
alpetrichcourdent
andauthored
aad support for ms sql server (windmill-labs#874)
Co-authored-by: Henri Courdent <122811744+hcourdent@users.noreply.github.com>
1 parent a43e6f0 commit b338e56

File tree

12 files changed

+42
-7
lines changed

12 files changed

+42
-7
lines changed
-274 KB
Loading
Binary file not shown.

docs/getting_started/0_scripts_quickstart/5_sql_quickstart/index.mdx

Lines changed: 12 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -147,16 +147,21 @@ Fill out the form with the information of your MS SQL instance and "Test connect
147147

148148
![Paste in Resource Values](./fill_mssql.png.webp)
149149

150-
| Property | Type | Description | Default | Required | Where to Find |
151-
| -------- | ------ | --------------- | ------- | -------- | ------------------------------------------------------------------------------------- |
152-
| host | string | Instance host | | true | Your hosting provider's control panel or in your server's MS SQL configuration file |
153-
| port | number | Instance port | | false | Your hosting provider's control panel or in your server's MS SQL configuration file |
154-
| user | string | Username | | true | Created in MS SQL (e.g., via SQL Server Management Studio) or provided by your hosting |
155-
| dbname | string | Database name | | true | Created in MS SQL (e.g., via SQL Server Management Studio) or provided by your hosting |
156-
| password | string | User's password | | true | Created in MS SQL (e.g., via SQL Server Management Studio) or provided by your hosting |
150+
| Property | Type | Description | Default | Required | Where to Find |
151+
| -------- | ------ | --------------- | ------- | -------- | ------------------------------------------------------------------------------------- |
152+
| host | string | Instance host | | true | Your hosting provider's control panel or in your server's MS SQL configuration file |
153+
| port | number | Instance port | | false | Your hosting provider's control panel or in your server's MS SQL configuration file |
154+
| user | string | Username | | true | Created in MS SQL (e.g., via SQL Server Management Studio) or provided by your hosting |
155+
| dbname | string | Database name | | true | Created in MS SQL (e.g., via SQL Server Management Studio) or provided by your hosting |
156+
| password | string | User's password | | true | Created in MS SQL (e.g., via SQL Server Management Studio) or provided by your hosting |
157+
| aad_token| object | OAuth token AD | | true | Either username/password or aad_token should be provided. Requires OAuth setup in Windmill |
157158

158159
To specify the application intent for read-only requests, add `-- ApplicationIntent=ReadOnly` to the script.
159160

161+
:::info
162+
When using domain credentials via Entra (Azure Active Directory) you need to add the scope `https://database.windows.net//.default` to the [Windmill OAuth instance setting](../../misc/setup_oauth#azure).
163+
:::
164+
160165
### BigQuery
161166

162167
To be able to connect to a [BigQuery](https://cloud.google.com/bigquery) instance, we'll need to define a Resource with the `BigQuery` Resource Type first.
78.7 KB
Loading
29.7 KB
Binary file not shown.
140 KB
Loading
Binary file not shown.
60.6 KB
Loading
19.7 KB
Binary file not shown.
69.7 KB
Loading

0 commit comments

Comments
 (0)