Creating SQL Server databases

Create databases with SQL Server. You can use the database wizard or run the SQL scripts that are provided with HCL Connections™.

Attention: The HCL Connections 8.0 database wizard does not create the database for the Community Highlights / Connections Engagement Center (CEC) or Feature Foundation | Export entries to PDF and provides support for Tailored Experience. The Community Highlights database scripts are located in the folder - /Wizards/connections.sql/icec. The Feature Foundation database scripts are located in the folder - /Wizards/connections.sql/ic360. Refer to the procedure in this section to create the databases. You will need to manually run the SQL scripts that are provided with HCL Connections. See Creating databases for more information.

There are two methods available to create your databases: SQL scripts and the database wizard. The database wizard automates the process of creating databases for the applications that you plan to install. If the administrator does not have permission to access the databases for modification, use the SQL commands to manually create a database. Each database you create should be made for the exclusive use of an application. One database per application.

• Configuring Unicode for SQL Server databases
  Each database in your HCL Connections deployment must be configured for Unicode. This procedure must be completed before you install HCL Connections because you cannot configure the database Unicode collation after installation.
• Preparing the database wizard for SQL Server
  Before you can use the wizard to create databases for your HCL Connections deployment, prepare the database server.
• Using the database wizard for SQL Server
  Use the database wizard to create databases for the HCL Connections applications that you plan to install.
• Using the databse wizard in silent mode for SQL Server
  Run the database wizard in silent mode when you need an identical installation on multiple servers.
• Creating SQL Server databases manually
  Create Microsoft™ SQL Server databases with SQL scripts instead of using the HCL Connections database wizard.
• Creating multiple SQL database instances
  Create SQL database instances using the SQL Server installation wizard. If you need to have only one database instance, you can skip this task.

Parent topic:Creating databases