IPA - SCM and IPA passwords

Applies To

Invoice Processing Agility: 1.0 and higher

Password Changes in your Invoice Processing Agility (IPA) Environment.

Depending upon system configuration (e.g. SQLServer integrated security) and corporate password policy, it may be necessary to change IPA and SCM passwords. For IPA environments integrated with MarkView, corresponding changes may also need to be made in the associated MarkView environment. This Article is intended to help in identifying where password entries are stored and where review/update may be needed.

Invoice Processing Agility Client Database (IPA)

• Navigate to the TotalAgility IPA settings form url (~/TotalAgility/forms/ipa/IPA_Settings.form) and check/update the Connection String in the Client Database section.
• Within Solution Configuration Manager, check/update username and password combinations on the "Manage Database Connections" page (navigation: Manage Project Configuration -> Manage Database Connections).
• Within Solution Configuration Manager, check the Connection String in "Database Connection Settings" (navigation: Configure Project -> Global Settings -> Database Connection Settings).

Solution Configuration Manager Database (SCM)

• Review the <connectionStrings> section of the web.config file located in the IIS folder SCMWEB (example below):

  <connectionStrings>
  <add name="SCM" connectionString="Data
  Source=MyWindows2008R2Server\SQLSERVER2008R2;Initial Catalog=SCM;Integrated
  Security=False;User ID=sa;Password=*****;MultipleActiveResultSets=True"
  providerName="System.Data.SqlClient" />
  </connectionStrings>

MarkView

For IPA environments integrated with MarkView, corresponding changes may need to be made in the associated MarkView environment. Please see MarkView Article 3824 for details:

Password Changes in your MarkView Environment