Documentation Center

Accessing Archiver database directly

Access the Archiver database directly by configuring Archive Manager Explorer.

Procedure

  1. In the root of your Archive Manager Explorer Web application directory, open the Web.Config file in a text editor.
  2. Comment out the <applicationSettings> section.
  3. In the <appSettings> section, uncomment the database you are using—and comment out the database you are not using—and specify the connection details of your archiver database (Data Source, User Id, Password, and for SQL Server Database). For example:
    <!-- SQL Server Settings -->
    <add key="providerstring" value="System.Data.SqlClient"/>
    <add key="connectionstring" value="Data Source=DATASOURCE;User Id=USERNAME;Password=PASSWORD;Database=DATABASENAME"/>
    <add key="bindvariablecharacter" value="@"/>
    <!-- Oracle Settings -->
    <add key="providerstring" value="System.Data.OracleClient"/>
    <add key="connectionstring" value="Data Source=DATASOURCE;User Id=USERNAME;Password=PASSWORD;"/>
    <add key="bindvariablecharacter" value=":"/>
  4. If you have integrated authentication with SQL Server set up, you can remove the User Id and Password properties and their values from the connectionstring key and replace them with Integrated Security=true; instead. For example, in the example configuration for Microsoft SQL Server above, you would replace this line:
    <add key="connectionstring" value="Data Source=10.100.100.102;User Id=TridionArchiver;Password=tridion;Database=MyDatabase"/>

    with this line:

    <add key="connectionstring" value="Data Source=10.100.100.102;Integrated Security=true;Database=MyDatabase"/>
  5. Save and close the file.