Modify Transforms.xml File

The necessary installation files are located in the OPPSA\OPPSA-InstallTransformKit folder found on the release media provided. Copy this folder and all contents to the server where the OPPSA application will be installed.
Note: the folder and contents could be copied to any server for modification and preparation of the final windows installer package (.msi). The final install package (.msi) created from the steps outlined below needs to be copied and executed from the server where the OPPSA application will be installed.

Contents of the “OPPSA\OPPSA-InstallTransformKit” folder:

Locate the Transforms.xml file. Add and modify the transform property values based on your environment configuration. The Transforms.xml properties are used to create a windows installer package (.msi). See Appendix A: Sample Transforms.xml for a sample transform file. The properties are used for web.config settings for communication between OPPSA and Databases.

Note: Be sure to specify all properties and values in the transforms.xml as the installation logic will assume defaults if the property is not specified and could cause runtime errors.
Transform Property Description
SQLHOSTNAME

Property for Membership DB configuration for ASP.NET membership provider application authentication.

Fully qualified server name where new membership database is located.

SQLINSTANCENAME

Property for Membership DB configuration. Specify the name of the SQL Server instance.

SQLSESSIONHOSTNAME

Property for Session DB configuration for load balancer.

Fully qualified server name for session database.

This could be on the same database server as the membership database or a separate server. Specify existing session DB if load balancing configuration already exists and intend to use for this application as well.

SQLSESSIONINSTANCENAME

Property for Session DB configuration. Specify the name of the SQL Server instance.

USEINTEGRATEDSECURITY

Property to indicate type of trusted connection to use.

Values: 0-SQL Server Authentication, 1-Windows Authentication.

If using Windows Authentication, remove the user and password properties from the transform file:

OPPSA.AUTHSQLLOGIN, OPPSA.AUTHSQLPASSWORD

USEINTEGRATEDSECURITYSESSION

Property to indicate type of trusted connection to use.

Values: 0-SQL Server Authentication, 1-Windows Authentication.

If using Windows Authentication, remove the corresponding user and password properties from the transform file:

OPPSA.AUTHSESSIONSQLLOGIN, OPPSA.AUTHSESSIONSQLPASSWORD

OPPSA.AUTHSQLLOGIN

Property to define the membership authentication DB connection user that will be used by application to connect to the membership authentication DB.

If using Windows Authentication, remove this property.

OPPSA.AUTHSQLPASSWORD

Property to define the password for the membership authentication DB connection user that will be used by application to connect to the membership authentication DB.

If using Windows Authentication, remove this property.

Oppsa.AspNetMembershipDb

Property to define the name of the membership authentication DB.

Oppsa.AspNetStateDb

Property to define the name of the membership state/ session DB.

OPPSA.WebSite

Property to define the root website for where application service will be created in Internet Information Services (IIS). See Appendix B: Example of Internet Information Services (IIS) Transform Property values for example.

This property defines the default website root folder.

Add an imbedded note here that states:

If installing under “Default Web Site”, remove this property as the installation defaults to this root folder.

OPPSA.AppVirtualDirName

Property to define Application Pool Virtual Directory Name for IIS. See Appendix B: Example of Internet Information Services (IIS) Transform Property values.

The application pool is where to set up the account name responsible for running the application. This installation is using the default IIS account.

Note: This transform does not provide properties to change the default account.
OPPSA.AppPoolName

Property to define Application Pool Name for IIS. See Appendix B: Example of Internet Information Services (IIS) Transform Property values.

OPPSA.EXPEREENDPOINTADDRESS

URL for the Expere Service Endpoint.

Example: Value="http://labw6412hvm922.wkmnlab.net:8080/Common/WSEndpoint"/>

OPPSA.AUTHSESSIONSQLLOGIN

Property to define the membership session DB connection user.

If using Windows Authentication, remove this property.

If using Windows Authentication, remove this property.

OPPSA.AUTHSESSIONSQLPASSWORD

Property to define the password for the membership session DB connection user.

If using Windows Authentication, remove this property.

OPPSA.LogFileLocation

Property to define file location for the OPPSA log file. See Appendix C: Using Log Files.

Property Value Format: Value=C:\\ProgramData\\WKFS\\OPPSA\\OPPSA. (double backslash is required to escape the special character backslash)

Default path is: C:\ProgramData\WKFS\OPPSA\OPPSA. The Last element of path name defines the prefix of the filename and current date is appended. The filename is constructed as follows: OPPSACurrentDate.log

OPPSA.ApplicationName

Property to define application name in membership database.

OPPSA.MinPasswordAgeInDays

Property to define the minimum password age in days for OPPSA application users. Determines the period of time (in days) that a password must be used before the user can change it. You can set values between 1 and 999 days, or you can allow changes immediately by setting the number of days to 0.

OPPSA.MaxPasswordAnswerAttempts

Property to define the number of incorrect password attempts allowed before the OPPSA user will be locked.

OPPSA.TargetHostName

Property to define fully qualified name of the host where OPPSA application will be installed. This property is used for URL Rewrite https redirect configuration.

OPPSA.SHOWLEGACYFUNCTIONALITY

Property to define if non-hosted features should be available. For Hosted installations, this value MUST be set to “false".

OPPSA.WebHelpLink

Property to define the URL for WebHelp. Leave this default value in sample transform file for the Help link in the application to access online help.

OPPSA.PolicyLink

Property to define the URL for the Privacy and Policy information. Do not change this property. Tranform default: Value="http://www.wolterskluwerfs.com/privacy-cookies-policy.aspx"

OPPSA.SupportLink

Property to define the URL for Support information. Do not change this property. Transform default: Value="http://www.wolterskluwerfs.com/support/"