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
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.
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)