Creating an MSSQL database

We have included a SQL script file for each supported RDBMS into the Connections Engagement Center Release Package zip file. The SQL scripts can be found in the subdirectory SQLScripts.

Step	Instructions
1

|You might want to change the script file to better fit into your system.

Change the file and path of the database in the script file:

change line 4: C:\Data\MSSQL\ICEC_DATA1.mdf

Change the file & path of the log in the script file:

Change line 6: C:\Data\MSSQL\ICEC_LOG

Change the user for accessing the ICEC database:

Change Connections Engagement Center USER in section -- create user

| |2

|Open a command window and run the following command:

sqlcmd -S <yourserver> -i <path>/Create_ICEC_MSSQL_Database.sql

Close the command window.

|