ConferenceXP Archive Service 1.3 Installation Guide

In this guide, you’ll learn how to set up ConferenceXP Archive Service 1.3.

Contents

System requirements
Installing Archive Service
Setting up the Archive Service database
Changing Archive Service configuration settings
Additional information

System requirements

To run ConferenceXP Archive Service 1.3, you’ll need the following hardware and software:

• 3.0 GHz Intel Pentium 4 with 512 MB RAM, or better (recommended)
• 100 GB or larger hard drive, depending on your archiving needs
• 256 MB of RAM minimum; 1 GB of RAM recommended
• Microsoft Windows XP or Microsoft Windows Server 2003
• One of the following:
  • Microsoft SQL Server™ 2005 (all editions)
  • Microsoft SQL Server™ 2000 with Service Pack 4 (SP4)
  • Microsoft SQL Server 2000 Desktop Engine (MSDE) 2000 with SP4

Top

Installing Archive Service

After you make sure you have the required hardware and software, you’re ready to install Archive Service 1.3.

Download and install Archive Service 1.3

Install a default instance in SQL Server 2005 Express Edition

1. Start Microsoft SQL Server 2005 Express Edition Setup.
2. On the Registration Information screen, clear the Hide advanced configuration options check box, and then click Next.
3. Click Next.
4. On the Instance Name screen, click Default instance, and then click Next.
5. Follow the onscreen instructions to complete the installation.

Enable Archive Service to recognize a named instance of SQL Server 2005

1. Open the Archive Service folder, which is located by default in the C:\Program Files\Microsoft Research\ConferenceXP\ folder.
    
2. Edit the AddDatabase.sql file by doing the following:
   1. Open the AddDatabase.sql file in a text editor, such as Notepad.
   2. In the CREATE DATABASE ArchiveService section, for both Filename paths, change MSSQLServerLocation to the SQL Server Data folder, which is typically C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\.
      
      For example, change the following two lines:
      
      FILENAME = N'MSSQLServerLocation\ArchiveService.mdf',
      FILENAME = N'MSSQLServerLocation\ArchiveService_log.ldf',
      
      To:
      
      FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\ArchiveService.mdf',
      
      FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\ArchiveService_log.ldf',
      
      Where C:/Program%20Files/Microsoft%20SQL%20Server/MSSQL.1/MSSQL/DATA/ is the actual installation location.
       
   3. Save the AddDatabase.sql file in text-only format.
       
3. If you want to change the location, growth rate, or size of your ArchiveService database, following the Change the location, growth rate, or size of your ArchiveService database steps below.
    
4. Edit the ArchiveAdmin.exe.config file by doing the following:
   1. Open the ArchiveAdmin.exe.config file in a text editor, such as Notepad.
   2. In the following key, specify the instance name for the datasource.
      
      For example, change:
      <add key="MSR.LST.ConferenceXP.ArchiveService.SQLConnectionString" value="Data Source = .; Initial Catalog = ArchiveService; Integrated Security = SSPI; Pooling = false"/>
      
      To:
      <add key="MSR.LST.ConferenceXP.ArchiveService.SQLConnectionString" value="Data Source = .\InstanceName; Initial Catalog = ArchiveService; Integrated Security = SSPI; Pooling = false"/>
      
      Where InstanceName is the instance name of your database.
       
   3. Save the ArchiveAdmin.exe.config file in text-only format.
       
5. Edit the ArchiveWindowsService.exe.config file by doing the following:
   1. Open the ArchiveWindowsService.exe.config file in a text editor, such as Notepad.
   2. Uncomment the <appSetting> keys, and then specify the instance name for the datasource.
      
      For example, change:
      <appSettings>
           <!-- Add any of these as necessary to set up your archiver to work properly.
           <add key="MSR.LST.ConferenceXP.ArchiveService.SQLConnectionString" value="data source=.;initial catalog=ArchiveService;integrated security=SSPI"/>
           <add key="MSR.LST.ConferenceXP.ArchiveService.TCPListeningPort" value="8082"/>
           <add key="MSR.LST.ConferenceXP.ArchiveService.PersistenceName" value="Archive Service"/> -->
      </appSettings>
      
      To:
      <appSettings>
           <!-- Add any of these as necessary to setup your archiver to work properly. -->
            <add key="MSR.LST.ConferenceXP.ArchiveService.SQLConnectionString" value="data source=.\InstanceName>;initial catalog=ArchiveService;integrated security=SSPI"/>
           <add key="MSR.LST.ConferenceXP.ArchiveService.TCPListeningPort" value="8082"/>
           <add key="MSR.LST.ConferenceXP.ArchiveService.PersistenceName" value="Archive Service"/>
      </appSettings>
       
      Where InstanceName is the instance name of your database.
       
   3. Save the ArchiveWindowsService.exe.config file in text-only format.
       
6. Use Osql.exe, a SQL Server tool, to create the ArchiveService database by doing the following:
1. Open the Command Prompt window.
2. At the command prompt, change the current directory to the C:\Program Files\Microsoft Research\ConferenceXP\Archive Service directory.
3. At the command prompt, type:
    
   osql.exe –E –S .\InstanceName –i AddDatabase.sql
   
   
4. At the command prompt, type:
    
   osql.exe –E –S .\InstanceName –i AddSPs.sql
   
   Where InstanceName is the instance name of your database. For SQL Server Express, the default instance name is SQLExpress.
    
7. Stop and then start the Archive Service.

Top

Setting up the Archive Service database

You can change the ArchiveService database initialization settings by editing the SQL script file, AddDatabase.sql, located in the Archive Service folder. The default settings install the database on the C drive with a growth rate of 50 MB and a default size of 100 MB. We recommended that you restrict the growth rate to a small number of bytes, because the Archive Service must cache incoming data while SQL Server is growing the database. Setting the growth rate too high may result in losing data during recording.

Change the location, growth rate, or size of your ArchiveService database

1. If you clicked Yes during setup to initialize the ArchiveService database, open Enterprise Manager and delete the ArchiveService database.
2. Open the Archive Service folder, which is located by default in the C:\Program Files\Microsoft Research\ConferenceXP\ folder.
3. Open the AddDatabase.sql file in a text editor, such as Notepad.
4. Make the changes you want for the location, growth rate, or size of the ArchiveService database, and then save the file in text-only format.
5. Use Osql.exe, a SQL Server tool, to create the ArchiveService database by doing the following:
   1. Open the Command Prompt window.
   2. At the command prompt, change the current directory to the C:\Program Files\Microsoft Research\ConferenceXP\Archive Service directory.
   3. At the command prompt, type:
       
      osql.exe –E –i AddDatabase.sql
       
   4. At the command prompt, type:
       
      osql.exe –E –i AddSPs.sql

Top

Changing Archive Service configuration settings

You can change Archive Service settings, such as the TCP Listening port it listens on or the timeout setting, by editing the Archive Service configuration files, located in the <install location>\Microsoft Research\ConferenceXP\Archive Service folder. After making changes to a configuration file, restart the Archive Service to make sure the new settings take effect.

Change the TCP Listening port

1. Open the ArchiveWindowsService.exe.config file, located in the Archive Service folder, in a text editor, such as Notepad.
2. Edit the value for the following key:
   
   <add key="MSR.LST.ConferenceXP.ArchiveService.TCPListeningPort" value="8082"/>
   
   Where 8082 is the default TCP listening port.
    
3. Save the file in text-only format.
4. Restart the Archive Service.

Change the timeout value

1. Open the ArchiveAdmin.exe.config file, located in the Archive Service folder, in a text editor, such as Notepad.
2. Edit the value for the following key:
   
   <add key="MSR.LST.ConferenceXP.ArchiveService.CommandTimeout" value="600"/>
   
   Where 600 is the number of seconds that Archive Service waits for a response before timing out.
    
3. Save the file in text-only format.
4. Restart the Archive Service.

Top

Additional information

For more information about setting up and using the Archive Service in ConferenceXP 3.5, see ConferenceXP Client 3.5 Help.

Top