Set Up Responder Mobile Tables

This step requires that you have SQL Server 2008 Express or SQL Server 2008 installed. Be sure to install this application before continuing with the steps below. Responder Mobile provides an executable that allows you to easily create the Responder Mobile tables in a SQL Server 2008 Express database.

After setting up the Responder Mobile tables, ensure the user that will be running Mobile Services has permissions to execute the following operations in your SQL Express database: Reading, Writing, Updates and Deletes.

The execution of ConfigureMobileApplication.exe will result in a large number of changes synchronized to each client. It is not recommended that you run this tool after the initial set up.

If the database name is changed in the configuration file before the user runs ConfigureMobileApplication.exe but after clients have synchronized, the client database will become out of sync with the server and become unusable.

Install SQL Server 2008 Express or SQL Server 2008. When selecting which extension to install, select: SQL Server 2008 Management Studio Express.
Browse to the Responder Server installation directory (by default: C:\Program Files (x86)\Miner and Miner\Responder\Server).
Open ConfigureMobileApplication.exe.config.

Look for the following XML:

	Copy Code
<property name="connection.connection_string"> Data Source=YourMachineName\SQLEXPRESS;Initial Catalog=ResponderDatabase;Integrated Security=True;Pooling=False </property>

Set the Data Source equal to the name of the machine on which SQL Server 2008 Express is installed. In the example above, the machine name is YourMachineName (e.g., YourMachineName\SQLEXPRESS).
Set the Initial Catalog to the name of your new SQL Express database. The default is ResponderDatabase. If you're running this tool for the first time, this database does not exist and you can name it anything you'd like. Note that this database is referenced in other configuration files and the name should appear the same.

Look for the following XML:

	Copy Code
<property name="default_schema">ResponderDatabase.dbo</property>

This is the name of the SQLEXPRESS database. The default is ResponderDatabase.dbo. If you have changed this name, modify this setting to reflect the new name.

Look for the following XML:

	Copy Code
<appSettings> <add key="DatabaseUpdateUser" value="YourMachineName\ASPNET"/> </appSettings>

Set the value key to the user that should be used to run the Sync Service. This user should already have a login created in the database server instance. Be sure to include the domain. If you're setting up the Responder Mobile tables on an XP machine, this value MUST be the local ASPNET user (e.g., machinename\aspnet).

On a Windows 7 OS machine, the user will be NT AUTHORITY\Network Service. To ensure this, view the Application Pool setting in the IIS Manager. This user must match the Identity property for the Application Pool.

Save and close ConfigureMobileApplication.exe.config.

Now that you have the configuration complete, you will need to run the application that creates the tables in your SQL Server Express database.

In the same directory as the configuration file (by default: C:\Program Files (x86)\Miner and Miner\Responder\Server), double-click ConfigureMobileApplication.exe.
You will be prompted to confirm that you want to delete all existing tables from the ResponderDatabase task database and recreate them. Press Y on the keyboard and press Enter.

When the application has finished updating the tables, close the window. Successful completion will look similar to the example below.

To be able to change the default and sync more than 255 characters between the Responder Mobile Client and the Responder Enterprise database you must take the following steps:

Note the field lengths for remarks/comments fields in the Responder enterprise database. Verify that the field lengths are the same across the active, history, and archive tables. If these lengths are different, you will see errors.
In the Responder Mobile database (by default called “ResponderDatabase”), alter the field lengths for the VALUE field on the TASKFIELD table, the DESCRIPTION field on the TASK table, and the VALUE field on the TASKFIELDELEMENT table. The field lengths should be set to have a length which matches the greatest remarks/comments field length on your Responder enterprise database.
If you have already implemented and used Responder Mobile and are now changing field sizes from the default, delete all SQL Server Compact databases from your Responder Client machines. By default these are located at “C:\users\[username]\AppData\Roaming\Miner and Miner\Responder” where [username] is the username of any user who has opened and logged into the Responder Mobile Client. The file will have a name similar to “33__Tasks.sdf”.