12.7.3 Configuring SQL Server for manually installed JBoss

Before you configure the SQL Server data source, you must have the AEM forms database created on SQL Server. (See Creating a SQL Server database.)

1. Copy the database profiles from [DVD root]\third_party\jboss.zip\ [JBoss_root]\standalone\configuration to the [AppServer_root]\standalone\configuration directory.

2. Open the adobe-ds.xml file in a text editor and modify the <datasource> element with your SQL Server connection settings:

   <connection-url>jdbc:sqlserver://localhost:1433;DatabaseName=adobe</connection-url> 
   <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class> 

3. Replace the following values with values that are specific to your database:

   • localhost : The name, IP address, or fully-qualified path of the computer that hosts the database. The default is localhost .

   • 1433 : The port used to access the database.

   • adobe : The name of the database that stores the AEM forms data. You will need to update the default value, adobe , with your database name.

4. Change the <driver-class> element as follows:

   <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>

5. In the lines that follow the <driver-class> settings, locate the user-name and password settings and replace the default values with the user name and password that the application server uses to access your database. Modify the minimum and maximum values for the data source connections:

   • IDP_DS:

     <min-pool-size>1</min-pool-size> 
     <max-pool-size>30</max-pool-size>

   • EDC_DS:

     <min-pool-size>1</min-pool-size> 
     <max-pool-size>30</max-pool-size>

     Note: If your forms server handles heavy load, increase the number of maximum JDBC connections to ensure that all jobs are processed. In such cases, increase <max-pool-size> to 50 or more for both IDP_DS and EDC_DS.

6. Save and close the file.

If you are running AEM forms with MSSQL database, you must create three datasources IDP_DS , EDC_DS , and DefaultDS .

1. Copy the database profiles from [DVD root]\third_party\jboss.zip\ [JBoss_root]\standalone\configuration to the [AppServer_root]\standalone\configuration directory.

2. Open the [JBoss_root]/domain/configuration/domain_mssql.xml file for editing.

3. Locate the <datasources> tag and delete all the child nodes.

4. To create the IDP_DS datasource, in the <datasources> node, add the following lines:

   <datasources> 
                       <datasource jta="true" jndi-name="java:/IDP_DS" pool-name="IDP_DS" enabled="true" use-java-context="true"> 
                           <connection-url>jdbc:sqlserver://localhost:1433;DatabaseName=adobe</connection-url>               
                           <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class> 
                           <driver>sqlserver</driver> 
                           
                           <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation> 
                           <pool> 
                               <min-pool-size>1</min-pool-size> 
                               <max-pool-size>30</max-pool-size> 
                           </pool> 
                           <security> 
                               <user-name>DB_USER</user-name> 
                               <password>DB_PASSWORD</password> 
                           </security> 
                           <timeout> 
                               <blocking-timeout-millis>20000</blocking-timeout-millis> 
                               <idle-timeout-minutes>2</idle-timeout-minutes> 
                           </timeout> 
                           <statement> 
                               <prepared-statement-cache-size>20</prepared-statement-cache-size> 
                           </statement> 
                       </datasource>

5. To create the EDC_DS datasource, after the IDP_DS datasource nodes, in the <datasources> node, add the following lines:

   <datasource jndi-name="java:/EDC_DS" pool-name="EDC_DS" enabled="true" use-java-context="true"> 
                           <connection-url>jdbc:sqlserver://localhost:1433;DatabaseName=adobe</connection-url>               
                           <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class> 
                           <driver>sqlserver</driver> 
                           
                           <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation> 
                           <pool> 
                               <min-pool-size>1</min-pool-size> 
                               <max-pool-size>30</max-pool-size> 
                           </pool> 
                           <security> 
                               <user-name>DB_USER</user-name> 
                               <password>DB_PASSWORD</password> 
                           </security> 
                           <timeout> 
                               <blocking-timeout-millis>20000</blocking-timeout-millis> 
                               <idle-timeout-minutes>2</idle-timeout-minutes> 
                           </timeout> 
                           <statement> 
                               <prepared-statement-cache-size>20</prepared-statement-cache-size> 
                           </statement> 
                       </datasource>

6. To create the DefaultDS datasource, after the EDC_DS datasource nodes, in the <datasources> node, add the following lines:

   <datasource jndi-name="java:/DefaultDS" pool-name="DefaultDS" enabled="true" use-java-context="true"> 
                           <connection-url>jdbc:sqlserver://localhost:1433;DatabaseName=adobe</connection-url>               
                           <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class> 
                           <driver>sqlserver</driver> 
                           
                           <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation> 
                           <pool> 
                               <min-pool-size>1</min-pool-size> 
                               <max-pool-size>30</max-pool-size> 
                           </pool> 
                           <security> 
                               <user-name>DB_USER</user-name> 
                               <password>DB_PASSWORD</password> 
                           </security> 
                           <timeout> 
                               <blocking-timeout-millis>20000</blocking-timeout-millis> 
                               <idle-timeout-minutes>2</idle-timeout-minutes> 
                           </timeout> 
                           <statement> 
                               <prepared-statement-cache-size>20</prepared-statement-cache-size> 
                           </statement> 
                       </datasource>

7. Set the following database specfic values for datasources IDP_DS, EDC_DS, and DefaultDS:

   1. Localhost : The name, IP address, or fully-qualified path of the computer that hosts the database. The default is localhost

   2. 1433 : If MSSQL does not use the default port, provide the appropriate port number.

   3. DB_USER , DB_PASSWORD : Provide the credentials that the application server uses to access your database.

   4. Modify the minimum and maximum values for the data source connections:

      • IDP_DS:

        <min-pool-size>1</min-pool-size> 
        <max-pool-size>30</max-pool-size>

      • EDC_DS:

        <min-pool-size>1</min-pool-size> 
        <max-pool-size>30</max-pool-size>

      Note: If your forms server handles heavy load, increase the number of maximum JDBC connections to ensure that all jobs are processed. In such cases, increase <max-pool-size> to 50 or more for both IDP_DS and EDC_DS.

8. Save and close the file.

1. Open the [appserver root] /standalone/configuration/lc_turnkey.xml file in a text editor and add the following lines within the <authentication> element:

   Replace :� 
   � 
   <security-domain name="EncryptDBPassword">� 
                       <authentication>� 
                           <login-module code="org.picketbox.datasource.security.SecureIdentityLoginModule" flag="required">� 
                               <module-option name="userName" value="adobe"/>� 
                               <module-option name="password" value="-3bfaa32dfe43f65b207a6df87216de44"/>� 
                               <module-option name="managedConnectionFactoryName" value="jboss.jca:name=DefaultDS,service=LocalTxCM"/>� 
                           </login-module>� 
                       </authentication>� 
                   </security-domain>� 
             <security-domain name="EncryptDBPassword_IDP_DS">� 
                       <authentication>� 
                           <login-module code="org.picketbox.datasource.security.SecureIdentityLoginModule" flag="required">� 
                               <module-option name="userName" value="adobe"/>� 
                               <module-option name="password" value="-3bfaa32dfe43f65b207a6df87216de44"/>� 
                               <module-option name="managedConnectionFactoryName" value="jboss.jca:name=IDP_DS,service=LocalTxCM"/>� 
                           </login-module>� 
                       </authentication>� 
                   </security-domain>� 
           <security-domain name="EncryptDBPassword_EDC_DS">� 
                       <authentication>� 
                           <login-module code="org.picketbox.datasource.security.SecureIdentityLoginModule" flag="required">� 
                               <module-option name="userName" value="adobe"/>� 
                               <module-option name="password" value="-3bfaa32dfe43f65b207a6df87216de44"/>� 
                               <module-option name="managedConnectionFactoryName" value="jboss.jca:name=EDC_DS,service=LocalTxCM"/>� 
                           </login-module>� 
                       </authentication>� 
                   </security-domain>�

2. Replace the bold values with values that are specific to your database.

3. Save and close the file.

4. Start JBoss.

1. Add the sqljdbc_auth.dll file to the Windows systems path (C:\Windows) on the computer that is running JBoss. The sqljdbc_auth.dll file is located within the Microsoft SQL JDBC 4.0 driver installation. The default location is [ SQL_root ]/sqljdbc_3.0/enu/auth/x86 for 32-bit operating systems and [SQL_root]/sqljdbc_3.0/enu/auth/x64 for 64-bit operating systems.

2. Open the properties for the JBoss for AEM forms service or the JBoss service that you configured, and click the Log On tab.

3. Select This Account and type the value of a valid user account. This change is not required if you are running JBoss from the command line.

4. Change SQL Server Security from Mixed mode to Windows Authentication only.