Johnson Controls P2000 Quick guide

P2000
Security Management System
Version 3.10 and higher, June, 2010
24-10515-21 Revision –
Enterprise Configuration

Security Solutions
[phone]
www.johnsoncontrols.com
P2000
Security Management System
Enterprise Configuration
Version 3.10 and higher, June, 2010
24-10515-21 Revision –

Copyright 2010
Johnson Controls, Inc.
All Rights Reserved
No part of this document may be reproduced without the prior permission of Johnson Controls, Inc.

Acknowledgment
Cardkey P2000, BadgeMaster, and Metasys are trademarks of Johnson Controls, Inc.
All other company and product names are trademarks or registered trademarks of their
respective owners.
If this document is translated from the original English version by Johnson Controls, Inc., all
reasonable endeavors will be used to ensure the accuracy of translation. Johnson Controls, Inc.
shall not be liable for any translation errors contained herein or for incidental or consequential
damages in connection with the furnishing or use of this translated material.
Due to continuous development of our products, the information in this document is subject to
change without notice. Johnson Controls, Inc. shall not be liable for errors contained herein or
for incidental or consequential damages in connection with furnishing or use of this material.
Contents of this publication may be preliminary and/or may be changed at any time without any
obligation to notify anyone of such revision or change, and shall not be regarded as a warranty.
Declaration of Conformity
This product complies with the requirements of the European Council Electromagnetic
Compatibility Directive 2004/108/EEC and the Low Voltage Directive 2006/95/EEC.
This equipment must not be modified for any reason and it must be installed as stated in the
Manufacturer’s instruction.
If this shipment (or any part thereof) is supplied as second-hand equipment, equipment for sale
outside the European Economic Area or as spare parts for either a single unit or system, it is not
covered by the Directives.

TABLE OF CONTENTS
24-10515-21 Rev. – v
This document contains confidential and proprietary information of Johnson Controls, Inc.
© 2010 Johnson Controls, Inc.
Chapter 1: Introduction
About This Manual................................................................................................................................... 1-1
Manual Summary..................................................................................................................................... 1-1
Technical Support ............................................................................................................................ 1-2
Qualification for Installation and Use................................................................................................ 1-2
Note on Other Manufacturer’s Documentation................................................................................. 1-2
Manual Conventions ........................................................................................................................ 1-2
About the P2000 Enterprise Configuration .............................................................................................. 1-3
Key Terms........................................................................................................................................ 1-4
P2000 Publications .......................................................................................................................... 1-5
Chapter 2: Configuring P2000 Central Server
SQL Server Login Account ...................................................................................................................... 2-2
Creating the “psqlserver” Account.................................................................................................... 2-2
Logging into the “psqlserver” Account.............................................................................................. 2-8
Connecting to the SQL Server ................................................................................................................. 2-8
Establishing Shared Directories............................................................................................................. 2-11
Configuring Publisher and Distributor .................................................................................................... 2-14
Generating P2000 Stored Procedures........................................................................................... 2-19
Establishing an Enterprise System ........................................................................................................ 2-20
Populating the Enterprise Settings......................................................................................................... 2-21
Setting Up P2000 Publications .............................................................................................................. 2-22
Snapshots.............................................................................................................................................. 2-25
Replication Set Identity Range............................................................................................................... 2-26
Chapter 3: Merging Data Between Sites
Merging Data Between Sites ................................................................................................................... 3-1
Live System Upgrade to Enterprise Configuration Using Additional Hardware ............................... 3-2
Live System Upgrade to Enterprise Configuration Without Additional Hardware .......................... 3-12
Rules for Data Merging .......................................................................................................................... 3-17
Chapter 4: Configuring P2000 Regional Server
Preparing for Configuration...................................................................................................................... 4-1
Changing the Login Account.................................................................................................................... 4-1
Connecting to the SQL Server ................................................................................................................. 4-4
Establishing Subscriptions ....................................................................................................................... 4-4
Replication Set Identity Range............................................................................................................... 4-17

Table of Contents Enterprise Configuration
vi 24-10515-21 Rev. –
This document contains confidential and proprietary information of Johnson Controls, Inc.
© 2010 Johnson Controls, Inc.
Appendix A: Publications
Appendix B: Important Notes
Initialization ......................................................................................................................................B-1
Deadlocks and Retries .....................................................................................................................B-1
Identity Columns ..............................................................................................................................B-1
Primary Key Violation.......................................................................................................................B-1
Calling sp_adjustpublisheridentityrange...........................................................................................B-2
Connectivity Loss .............................................................................................................................B-2

24-10515-21 Rev. – 1-1
Chapter 1
This document contains confidential and proprietary information of Johnson Controls, Inc.
© 2010 Johnson Controls, Inc.
INTRODUCTION
The P2000 Enterprise Configuration advanced feature allows customers with multiple sites
to communicate with each other to share Cardholder/Badge information. Cardholders can be
granted access to doors at all assigned sites within the Enterprise system.
In the P2000 Enterprise Configuration, one P2000 site becomes the P2000 Central Site and
all other P2000 systems within the enterprise become P2000 Regional Sites. Each regional
site synchronizes its data with the central site. Database replication is implemented through
the use of Microsoft SQL Server database technologies.
ABOUT THIS MANUAL
This document is to be used as a supplement to the P2000 documentation. It details the
information concerning the P2000 Enterprise Configuration:
Configuring the P2000 Central Site
Moving data from existing P2000 Regional Sites to the P2000 Central Site
Configuring a P2000 Regional Site
NOTE
Throughout this manual, the terms Pegasys and P2000 are used
interchangeably.
NOTE
The screen captures shown in this manual may differ slightly, depending
on the firmware version you are using.
MANUAL SUMMARY
Chapter 1: Introduction, defines the key terms and conventions used throughout the
manual, as well as provides introduction to the P2000 Enterprise system.
Chapter 2: Configuring P2000 Central Server, contains instructions on setting up
the P2000 central server for Enterprise Configuration.

Introduction Enterprise Configuration
1-2 24-10515-21 Rev. –
This document contains confidential and proprietary information of Johnson Controls, Inc.
© 2010 Johnson Controls, Inc.
Chapter 3: Merging Data Between Sites, describes how to move P2000 Enterprise
Regional Site data to the P2000 Enterprise Central Site.
Chapter 4: Configuring P2000 Regional Server, provides instructions for
establishing P2000 regional server as a Database Subscriber.
Appendix A: Publications, identifies publications and their corresponding articles
(database tables).
Appendix B: Important Notes,provides reference information useful for
troubleshooting.
Technical Support
Technical assistance is provided to Johnson Controls authorized dealer
representatives from 5 a.m. PT (Pacific Time) to 5 p.m. PT Monday through Friday.
System users can get answers to operator questions by calling the local Johnson
Controls Inc. sales/service office.
The authorized dealer representatives can also provide you with information on the
maintenance contracts and the on-site field service.
Qualification for Installation and Use
Installers and users of the P2000 Enterprise Configuration System must complete
appropriate training and obtain certification prior to installing and using this
advanced feature.
Note on Other Manufacturer’s Documentation
Johnson Controls does not duplicate documentation of other equipment
manufacturers. When necessary, as in some installation procedures, we will provide
documentation that supplements other manufacturer’s documentation. When
unpacking your equipment, keep all original manufacturer documentation for
future reference.
Manual Conventions
The following items are used throughout this manual to indicate special
circumstances, exceptions, important points regarding the equipment or personal
safety, or to emphasize a particular point.
NOTE
Notes indicate important points or exceptions to the information provided in
the main text.