Blackberry PRD-10459-016 Administration Guide - Page 115

Administration Guide Configuring the BlackBerry Configuration Database for one-way transactional replication in an environment that includes Microsoft SQL Server 2005 or 2008 11. Click OK. Permit access to the BlackBerry Configuration Database instances 1. In the Microsoft® SQL Server® Management Studio, connect to the database server that hosts the BlackBerry® Configuration Database. 2. Right-click the BlackBerry Configuration Database. Click Properties. 3. Click Options. 4. In the State section, in the Restrict Access drop-down list, select Multiple. 5. Click OK. 6. Repeat steps 1 to 5 for the replicated BlackBerry Configuration Database. Configure the publication for the BlackBerry Configuration Database 1. In the Microsoft® SQL Server® Management Studio, in the left pane, navigate to the database server that hosts the BlackBerry® Configuration Database. 2. Click Replication. 3. Right-click Local Publications. Click New Publication. 4. If the Welcome dialog box appears, click Next. 5. If this is the first time that you are configuring a publication on the database server, perform the following actions: • Select will act as its own Distributor. Click Next. • In the Snapshot folder field, type the network location of the snapshot folder. Click Next. 6. In the list of databases, select the BlackBerry Configuration Database name. Click Next. 7. Click Transactional publication. Click Next. 8. In the Objects to publish list, select Tables, Stored Procedures, Views, and User Defined Functions. 9. If you installed the BlackBerry database notification system on the computer, expand Tables and clear the ServiceConfig table and the ServiceTable table. Click Next. 10. If the Article Issues dialog box appears, click Next. 11. If the Filter Table Rows dialog box appears, click Next. 12. Select Schedule the Snapshot Agent to run at the following times. 13. Accept or change the default schedule. Click Next. 14. On the Snapshot Agent Security page, click Security Settings. 15. Select Run under the following Windows account. 16. Type the user name and password of a domain account that has local administrative permissions. 17. Select By impersonating the process account. 18. Click OK. Click Next. 19. Select Create the publication. Click Next. 113