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 <i>(new logins)</i>.


User Name

Password

Database

i2b2demodata

demouser

i2b2demodata

i2b2hive

demouser

i2b2hive

i2b2imdata

demouser

i2b2imdata

i2b2metadata

demouser

i2b2metadata

i2b2pm

demouser

i2b2pm

i2b2workdata

demouser

i2b2workdata


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