Steps to Create i2b2 Database Users
The following outlines the steps to take when creating the user accounts in your SQL Server database.
| indent |
|---|
|
1. Log into SQL Server Management Studio |
| indent |
|---|
|
2. Create the following databases |
| indent |
|---|
|
Database |
|---|
i2b2demodata | i2b2hive | i2b2imdata | i2b2metadata | i2b2pm | i2b2workdata |
|
| indent |
|---|
|
3. Create the following users <i>(new logins)</i>. |
| indent |
|---|
|
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. |
