Introduction The following document describes how to install PrivateWire in high availability mode using database replication. For more information please refer to PrivateWire documentation chapter 21 This document is about to describe an advance PrivateWire Gateway configuration, and SQL Server configuration assuming the reader has pretty good understanding and knowledge of PrivateWire Gateway, SQL Server and networking. When performing SQL replication between PrivateWire gateways, we recommend replicating only the users and group tables (list of tables to replicate can be found later in this document). Meaning that all other information such as rules or setup parameters should be entered in both replicated gateways manually. Prerequisites 1. It is assumed that the reader has pretty good knowledge of PrivateWire and a good knowledge of Microsoft SQL Server and how to setup Microsoft SQL server in database replication mode. 2. Environment: Two Gateways installed using ODBC wizard on Microsoft SQL Server Database. 3. Each gateway need to have a special gateway ID assigned to (it requested during the ODBC compliant installation) 4. All of the gateways should be joined to Microsoft Domain (NT,2000,2003) 5. In order to eliminate some permissions and access problems SQL Server services (Ms SQL Server and SQL Server Agent) should be configure to run as the same domain user account (not local system account) Note: Be sure that the domain user account you are using has local administrator privileges on the gateways. 6. Use the PrivateWire administration to define the gateway configurations such as rules-tables, definitions, servers and setup parameters on each gateway before establishing the replication process. 7. The gateway's rules table should allow communication between the gateways on the SQL server port (default is 1433), and Microsoft Directory services ports.

» Free PDF eBooks Download
» Tutorial Database MsSQL