# SQL Server on Windows (local) (Prisma ORM v6) (/docs/orm/v6/overview/databases/sql-server/sql-server-local)

> For the complete Prisma documentation index, see [llms.txt](https://www.prisma.io/docs/llms.txt). A markdown version of any docs page is available by appending `.md` to its URL.

Set up and configure SQL Server on Windows.

Location: ORM > v6 > Core Concepts > Supported databases > SQL Server > SQL Server on Windows (local)

> [!NOTE]
> Quick summary
> 
> Learn how to set up and configure Microsoft SQL Server locally on Windows for use with Prisma ORM.

To run a Microsoft SQL Server locally on a Windows machine:

1. If you do not have access to an instance of Microsoft SQL Server, download and set up [SQL Server 2019 Developer](https://www.microsoft.com/en-us/sql-server/sql-server-downloads).

2. Download and install [SQL Server Management Studio](https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15).

3. Use Windows Authentication to log in to Microsoft SQL Server Management Studio (expand the **Server Name*&#x2A; dropdown and click &#x2A;*\<Browse for more...>** to find your database engine):

![The New Query button in SQL Server Management Studio](https://www.prisma.io/img/orm/connect-sql-server.png)

## Enable TCP/IP [#enable-tcpip]

Prisma Client requires TCP/IP to be enabled. To enable TCP/IP:

1. Open SQL Server Configuration Manager. (Search for "SQL Server Configuration Manager" in the Start Menu, or open the Start Menu and type "SQL Server Configuration Manager".)

2. In the left-hand panel, click **SQL Server Network Configuration** > **Protocols for MSSQLSERVER**

3. Right-click **TCP/IP** and choose **Enable**.

## Enable authentication with SQL logins (Optional) [#enable-authentication-with-sql-logins-optional]

If you want to use a username and password in your connection URL rather than integrated security, [enable mixed authentication mode](https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/change-server-authentication-mode?view=sql-server-ver15\&tabs=ssms) as follows:

1. Right-click on your database engine in the Object Explorer and click **Properties**.

2. In the Server Properties window, click **Security** in the left-hand list and tick the **SQL Server and Windows Authentication Mode** option, then click **OK**.

3. Right-click on your database engine in the Object Explorer and click **Restart**.

### Enable the `sa` login [#enable-the-sa-login]

To enable the default `sa` (administrator) SQL Server login:

1. In SQL Server Management Studio, in the Object Explorer, expand **Security** > **Logins** and double-click **sa**.

2. On the **General** page, choose a password for the `sa` account (untick **Enforce password policy** if you do not want to enforce a policy).

3. On the **Status** page, under **Settings** > **Login**, tick **Enabled**, then click **OK**.

You can now use the `sa` account in a connection URL and when you log in to SQL Server Management Studio.

> **Note**: The `sa` user has extensive permissions. You can also [create your own login with fewer permissions](https://learn.microsoft.com/en-us/sql/relational-databases/security/authentication-access/create-a-login?view=sql-server-ver15).

## Related pages

- [`SQL Server on Docker`](https://www.prisma.io/docs/orm/v6/overview/databases/sql-server/sql-server-docker): Download and use the Microsoft SQL Server Docker image.