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