I have attached a zip file that contains sql files for creating and populating an MSSQL database. Here is an overview of the changes I made to get it to work: Otrs-schema.mssql.sql (converted from otrs-schema.mysql.sql) -------------------------------------------------------------------- Changed all "AUTOINCREMENT" statements to "IDENTITY(1,1)" Changed: CREATE TABLE system_user to CREATE TABLE "system_user" The double quotes are needed or else MSSQL complains that "system" is a reserved keyword Changed INDEX commands. Example: Original: CREATE TABLE user_preferences ( user_id INTEGER NOT NULL, preferences_key VARCHAR (150) NOT NULL, preferences_value VARCHAR (250), INDEX index_user_preferences_user_id (user_id) ); Changed: CREATE TABLE user_preferences (v user_id INTEGER NOT NULL, preferences_key VARCHAR (150) NOT NULL, preferences_value VARCHAR (250), ); CREATE INDEX index_user_preferences_user_id on user_preferences (user_id) Had to move the index command outside of the () block. Had to add the word "CREATE" to the beginning of the index command. Had to specify in which table to create the index by using the keyword "on" and then stating a table name. Initial_insert.mssql.sql (changed from initial_insert.sql) ---------------------------------------------------- Changed all "MEDIUMTEXT" fields to "NTEXT" Changed all "LONGBLOB" fields to "TEXT" Placed doubles quotes around the table name system_user