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 |
Warning
When setting up the new logins make sure Enforce password expiration is NOT checked off.