Installing and preparing SQL Server
Use this information to install and configure SQL Server for use with HCL Digital Experience.
Before you begin
- Review the database considerations.
- Ensure the database that you plan to use is supported by this version of HCL Portal. Refer to the list of supported databases in the HCL Digital Experience detailed system requirements.
- Download a JDBC 6.2 compliant driver from Microsoft
Procedure
- Install SQL Server and all required patches.
- In the SQL
Server Setup, choose
the following:
- Complete the installation. Use the SQL Server documentation as a guide.
- Install the JDBC driver. Use Microsoft SQL
Server JDBC drivers
and enable XA connections:
- Download and install the Microsoft SQL Server JDBC driver; see Microsoft Download Center for information.
- Copy the sqljdbc_xa.dll file
from the xa sub-directory to the
following directory of the SQL
Server installation:
- Microsoft SQL Server 2012: C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn
- Microsoft SQL Server 2014: C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Binn
- Microsoft SQL Server 2016: C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Binn
- Start the database server.
- Ensure that the Distributed Transaction Coordinator is started. Verify this status in the list of services in the Computer Management console.
- Start the Microsoft SQL Server Management Studio and connect to the local database engine as the system administrator, sa.
- Select xa_install.sql from the sub-directory of the downloaded and extracted JDBC driver. and select
- Run the script by Select Note: Ignore any warnings that say that stored procedures cannot be found.
to run the script.
- To grant permission to a specific user to participate in distributed transactions with the JDBC driver, add the user to the SqlJDBCXAUser role.
- Complete the
following steps to enable XA Transactions in Windows™ Component Services:
- Start SQL Server.
- Connect at least one user to the SQL
Server instance.
A user can be granted permission to use several schema names, so a single user for each instance is sufficient.
What to do next
Use the Configuration Wizard to set up and configure the database to work with HCL Portal. You can use the wizard to create custom scripts that you or your database administrator can use to configure the database. You can also use the wizard to automatically set up and configure the database. The wizard creates instructions and scripts that are based on your selections and provided data.
When you use the wizard, you provide information about the
database for your environment.
Note: Before you enter your database name (
dbdomain.DbName
) in the Configuration Wizard,
check your database documentation for restrictions on character length.You cannot use the Database Transfer option in the configuration wizard to assign custom table spaces on your database server. You can perform manual steps to assign custom table spaces. Go to Assigning custom table spaces for more information.