Configuring P2000 Central Server Enterprise Configuration
2-24 24-10515-21 Rev. –
This document contains confidential and proprietary information of Johnson Controls, Inc.
© 2010 Johnson Controls, Inc.
4. Click the “Open File” button or go to File>Open>File.
5. Select the central server and click Conne
ct.
6. Browse for the Cr
eate All Publications.sql file (\Program Files\Johnson
Controls\Cardkey P2000\sql). Select it and click Open.
7. Remove the entire “EXEC” statement line for all such publications
that you
do not want to create (see “P2000 Publications” on page 1-5 for more
information on how to decide which publication
s to establish).
8. In the SQL Query Analyzer window, click the “Parse Query” button .
Wait for the message “Command(s) completed successfully” to appear in the
lower windo
w pane.
9. Once the syntax has been checked, click the ! Execute button. When the
query is complete, information about the number of affected rows will be
displayed. In addition, a “Query batch completed” message will appear at the
bottom of the right window panel.
It is recommended that you scroll down and
review error messages under the
Messages tab. Resolve any reported problems before proceeding.