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

2. Download and install SQL Server Management Studio.

3. Use Windows Authentication to log in to Microsoft SQL Server Management Studio (expand the Server Name* dropdown and click *\

** to find your database engine):

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.

If you want to use a username and password in your connection URL rather than integrated security, enable mixed authentication mode 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.

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.

• SQL Server on Docker: Download and use the Microsoft SQL Server Docker image.