How do I use the SQL Response client across domains?

Category: How do I?
Date: 08 Jun 2009
Product: SQL Response
SQL Response 1.2 and 1.3 allow you to place the client application in one domain, whilst the repository exists in another domain.

To be able to use a SQL Response client across domains, the domain based authentication needs to be disabled. Both the client settings and server config files must be modified as follows:

The client Settings - on the machine with the SQL Response client installed:

1. Using the Windows Explorer navigate to the following file:
C:\Documents and Settings\<User_Name>\Application data\Red Gate\SQL Response Client\ClientSettings.dat
2. Edit the file in Notepad.
3. Locate the line that = <SecureRemoting>True</SecureRemoting>
4. Change it so that it reads as <SecureRemoting>False</SecureRemoting>

<User_Name> = equals the user name running the SQL Response Client. If there is more than one user, using the SQL Response Client, repeat the above procedure for each user

The server config - the machine with the Alert Repository installed:

1. Using the Windows Explorer navigate to the following file:
C:\Program Files\Red Gate\SQL Response 1\Alert Repository\Config.xml
2. Edit the file and add the following line:
<SecureRemoting>False</SecureRemoting>

So the existing file may contain the following:

<?xml version="1.0" encoding="utf-8" ?>
<SqlResponseConfig>
<TcpPort>7398</TcpPort>
<DataDirectory>C:\Documents and Settings\All Users\Application Data\Red Gate\SQL Response 1\Alert Repository\</DataDirectory>
<ServiceType>user</ServiceType>
<ServiceStart>1</ServiceStart>
</SqlResponseConfig>

It must be modified to become:

<?xml version="1.0" encoding="utf-8" ?>
- <SqlResponseConfig>
<TcpPort>7398</TcpPort>
<DataDirectory>C:\Documents and Settings\All Users\Application Data\Red Gate\SQL Response 1\Alert Repository\</DataDirectory>
<ServiceType>user</ServiceType>
<ServiceStart>1</ServiceStart>
<SecureRemoting>False</SecureRemoting>
</SqlResponseConfig>

NB. If these settings do not match, it will not be possible to connect to the repository.

By default (ie on a clean install or an old config file) they should both be set to true either explicitly or implicitly.

After changing the configuration, the SQL Response repository service and the client should both be restarted..