Creating database

It is advised to use SQL Server Authentication instead of Windows Authentication. To enable it, select the server instance in Micorosft SQL Server Management Studio, go to Properties / Security / Server authentication and select SQL Server and Windows Authentication mode. The server instance needs to be restarted.

	Note
	Make sure you have: TCP/IP Enabled in SQL Server Network Configuration → Protocols TCP Port set to1433 in TCP/IP Properties → IP Addresses → IPAll

1. Create a new database

   CREATE DATABASE clover_db;

2. Enable Read Committed Snapshot Isolation on the new database

   ALTER DATABASE clover_db SET READ_COMMITTED_SNAPSHOT ON;

3. Create a new login role.

   CREATE LOGIN clover with PASSWORD = 'clover', DEFAULT_DATABASE = clover_db;

4. Connect to the database.

   USE clover_db;

5. Create a new database user.

   CREATE USER clover FOR LOGIN clover;

6. Add database role membership db_owner (Members of the db_owner fixed database role can perform all configuration and maintenance activities on the database, and can also drop the database).

   EXEC sp_addrolemember 'db_owner','clover';

Using MS SQL requires configuration of database server.

If you use a properties file for configuration, specify these parameters: jdbc.driverClassName, jdbc.url, jdbc.username, jdbc.password, jdbc.dialect. For example:

jdbc.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver

jdbc.url=jdbc:sqlserver://localhost:1433;instance=SQLSERVERINSTANCE;database=clover_db
jdbc.username=user
jdbc.password=pass
jdbc.dialect=org.hibernate.dialect.SQLServerDialect

Please do not forget to add a JDBC 4 compliant driver on the application server classpath. A JDBC driver that does not meet the JDBC 4 specifications will not work properly.

	Note
	Continue with:  Encrypted JNDI or CloverETL Server Activation