3.5.2.1 Configuring the data source files

Before you configure the SQL Server data source, you must have already created the LiveCycle database on SQL Server. (See Preparing to Install LiveCycle (Server Cluster).)

To modify the Adobe data source file:

  1. Open the [appserver root]/server/lc_sqlserver_cl/deploy/adobe-ds.xml file in a text editor and locate these lines:

    <connection-url>jdbc:sqlserver://localhost:1433;DatabaseName=adobe</connection-url> 
<user-name>adobe</user-name> 
<password>adobe</password>

  2. Replace the following text 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 that is used used to access the database. The default port is 1433.

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

  3. In the <user-name> and <password> tags, specify the user name and password that the application server uses to access the database. You will need to update the default values adobe and adobewith the credentials for your database.

  4. Repeat steps 1 to 3 for the remaning elements in IDP_DS and EDC_DS.

  5. Save the file.

To modify the SQL Server data source file:

  1. Open the [appserver root]/server/lc_sqlserver_cl/deploy/mssql-ds.xml file in a text editor and locate these lines:

    <connection-url>jdbc:sqlserver://localhost:1433;DatabaseName=adobe</connection-url> 
<user-name>adobe</user-name> 
<password>adobe</password>

  2. Replace the following text 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 that is used used to access the database. The default port is 1433.

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

  3. In the <user-name> and <password> tags, specify the user name and password that the application server uses to access the database. You will need to update the default values adobe and adobewith the credentials for your database.

  4. Save the file.

To configure Integrated Security on Windows:

  1. Modify the adobe-ds.xml file, located in [appserver root]\server\all\deploy, to add integratedSecurity=true to the connection URL, as in this example:

    jdbc:sqlserver://<serverhost>:<port>;databaseName=<dbname>;integratedSecurity=true.

  2. 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 with the Microsoft SQL JDBC 3.0 driver installation (default is <InstallDir>/sqljdbc_3.0/enu/auth/x86).

  3. Open the properties for the JBoss for Adobe LiveCycle ES3 service and click the Log On tab.

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

  5. Change SQL Server’s Security from Mixed mode to Windows Authentication only.

// Ethnio survey code removed