---
title: 3.3.3 Create User Accounts in SQL Server
description: "# Steps to Create i2b2 Database Users The following outlines the steps to take when creating the user accounts in your SQL Server database. 1. Log into SQL Server Management Studio 2. Create the following databases | **Database** | |…"
url: "https://i2b2.org/docs/3-3-3-create-user-accounts-in-sql-server/"
updated: "2026-09-15"
category: i2b2 Installation Guide / Chapter 3. Data Installation / 3.3 Create Database User Accounts
---

# 3.3.3 Create User Accounts in SQL Server

# Steps to Create i2b2 Database Users

The following outlines the steps to take when creating the user accounts in your SQL Server database.

1. Log into SQL Server Management Studio

2. Create the following databases

| **Database** |
| --- |
| i2b2demodata |
| i2b2hive |
| i2b2imdata |
| i2b2metadata |
| i2b2pm |
| i2b2workdata |

3. Create the following users *(new logins)*.

| **User Name** | **Password** | **Database** |
| --- | --- | --- |
| i2b2demodata | demouser | i2b2demodata |
| i2b2hive | demouser | i2b2hive |
| i2b2imdata | demouser | i2b2imdata |
| i2b2metadata | demouser | i2b2metadata |
| i2b2pm | demouser | i2b2pm |
| i2b2workdata | demouser | i2b2workdata |

Warning

When setting up the new logins make sure **Enforce password expiration** is **NOT** checked off.