3.5.2.1 Configuring the data source files

Open the [appserver root] /domain/configuration/domain_mssql.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>

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 AEM forms data. You will need to update the default value adobe with your database name.

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 adobe with the credentials for your database.

Repeat steps 1 to 3 for the remaning elements in IDP_DS , EDC_DS , and DefaultDS

Save the file.

Modify the domain_mssql.xml file, located in [appserver root] /domain/configuration, to add integratedSecurity=true to the connection URL, as in this example:

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

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 4.0 driver installation. You can download the driver from Microsoft Website.

Open the properties for the JBoss for AEM forms service and click the Log On tab.

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.

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