1--- 2layout: "docs" 3page_title: "MSSQL - Storage Backends - Configuration" 4sidebar_title: 'MSSQL' 5sidebar_current: "docs-configuration-storage-mssql" 6description: |- 7 The MSSQL storage backend is used to persist Vault's data in a Microsoft SQL Server. 8--- 9 10# MSSQL Storage Backend 11 12The MSSQL storage backend is used to persist Vault's data in a Microsoft SQL Server. 13 14- **No High Availability** – the MSSQL storage backend does not support high 15 availability. 16 17- **Community Supported** – the MSSQL storage backend is supported by the 18 community. While it has undergone review by HashiCorp employees, they may not 19 be as knowledgeable about the technology. If you encounter problems with them, 20 you may be referred to the original author. 21 22```hcl 23storage "mssql" { 24 server = "localhost" 25 username = "user1234" 26 password = "secret123!" 27 database = "vault" 28 table = "vault" 29 appname = "vault" 30 schema = "dbo" 31 connectionTimeout = 30 32 logLevel = 0 33} 34``` 35 36## `mssql` Parameters 37 38- `server` `(string: <required>)` – host or host\instance. 39 40- `username` `(string: "")` - enter the SQL Server Authentication user id or 41 the Windows Authentication user id in the DOMAIN\User format. 42 On Windows, if user id is empty or missing Single-Sign-On is used. 43 44- `password` `(string: "")` – specifies the MSSQL password to connect to 45 the database. 46 47- `database` `(string: "Vault")` – Specifies the name of the database. If the 48 database does not exist, Vault will attempt to create it. 49 50- `table` `(string: "Vault")` – Specifies the name of the table. If the table 51 does not exist, Vault will attempt to create it. 52 53- `schema` `(string: "dbo")` – Specifies the name of the schema. If the schema 54 does not exist, Vault will attempt to create it. 55 56- `appname` `(string: "Vault")` – the application name. 57 58- `connectionTimeout` `(int: 30)` – in seconds (default is 30). 59 60- `logLevel` `(int: 0)` – logging flags (default 0/no logging, 63 for full logging) . 61 62- `max_parallel` `(string: "128")` – Specifies the maximum number of concurrent 63 requests to MSSQL. 64 65## `mssql` Examples 66 67### Custom Database, Table and Schema 68 69This example shows configuring the MSSQL backend to use a custom database and 70table name. 71 72```hcl 73storage "mssql" { 74 database = "my-vault" 75 table = "vault-data" 76 schema = "vlt" 77 username = "user1234" 78 password = "pass5678" 79} 80``` 81