Accessing Archiver database directly
Access the Archiver database directly by configuring Archive Manager Explorer.
Procedure
- In the root of your Archive Manager Explorer Web application directory, open the
Web.Configfile in a text editor. - Comment out the
<applicationSettings>section. - 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 ServerDatabase). 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=":"/> - If you have integrated authentication with SQL Server set up, you can remove the
User IdandPasswordproperties and their values from theconnectionstringkey and replace them withIntegrated 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"/> - Save and close the file.