Putting some notes in here that relate to SQL Server specific isssues.

On linux boxes, accessing MS SQL is easiest using 'sqsh' a command-line Transact-SQL client: sqsh -S UHLSQLBRICCSDB
UHLBRICCSDB -U username -P password

On the primary MS SQL server provided by the UHL (UHLSQLBRICCSDB\UHLBRICCSDB), we have configured the following for use by the i2b2 instance on uhlbriccsapp02:

create database i2b2metadata
create database i2b2demodata
create database i2b2workdata
create database i2b2metadata2
create database i2b2demodata2
create database i2b2workdata2
create database i2b2_b1_metadata
create database i2b2_b1_data
create database i2b2_b1_workdata
create database i2b2hive
create database i2b2pm

And the following for use by the uhlbriccsapp03 i2b2:

create database i2b2_app03_metadata
create database i2b2_app03_demodata
create database i2b2_app03_workdata
create database i2b2_app03_metadata2
create database i2b2_app03_demodata2
create database i2b2_app03_workdata2
create database i2b2_app03_b1_metadata
create database i2b2_app03_b1_data
create database i2b2_app03_b1_workdata
create database i2b2_app03_hive
create database i2b2_app03_pm

Links

This is useful on rebuilding indexes: ​http://www.sqldbpros.com/2010/11/sql-server-rebuild-indexes-the-fastest-way/