Configuring a Microsoft™ SQL Server database for the HCL Launch server
To use an SQL Server database with the server, before you install the server, install the SQL Server database and provide the driver file for the server installation process.
Before you begin
Before you install the HCL Launch server, install an SQL Server database. Specify case-sensitive collation for the database. If you are evaluating HCL Launch, you can install the database on the same system as the HCL Launch server.
For example, the commands to create a database, create an SQL server user, and configure the database, might look like the following example:
CREATE DATABASE launch;
USE launch;
CREATE LOGIN launch WITH PASSWORD = 'password';
CREATE USER launch FOR LOGIN launch WITH DEFAULT_SCHEMA = launch;
CREATE SCHEMA launch AUTHORIZATION launch;
GRANT ALL TO launch;
SQL Server should have:
READ_COMMITTED_SNAPSHOT ON
SQL Server Compatibility should be set to 110.
Procedure
-
Obtain the SQL Server JDBC driver files from the Microsoft™ site.
When multiple drivers are available, you might need to consult with the database provider to determine which driver to use. The JDBC driver version that you must use might depend on the version of the database and the version of Java™ used by the HCL Launch server.
- Put the JDBC JAR file to installer_directory\lib\ext.
- Begin server installation. See Installing the server. When you are prompted for the database type, enter sqlserver.
- Provide the JDBC driver class HCL Launch uses
to connect to the database.The default value is
com.microsoft.sqlserver.jdbc.SQLServerDriver
. - Next, provide the JDBC connection string.The format depends on the JDBC driver. Typically, it is similar to the following code:
jdbc:sqlserver://dbURL:dbPORT;databaseName=dbNAME
For example, the connection string to database that is on the same computer as the HCL Launch server and that uses the default port resembles the following code:jdbc:sqlserver://localhost:1433;databaseName=launch
If your database server uses integrated security, include the integratedSecurity parameter, as in the following example:jdbc:sqlserver://databaseServer:1433;databaseName=launch;integratedSecurity=true;
Note: Before using theintegratedSecurity=true
option, place thesqljdbc_auth.dll
file in the\bin
directory of your JRE. The file can be found in the\auth\x86
or\auth\x64
directory of the SQL Server installation files. - Finish by entering the database user name and password.
-
Before you start the server, log into the database and run the following command:
Use the name of the database forALTER DATABASE databaseName SET READ_COMMITTED_SNAPSHOT ON
databaseName
. - Start the server.