How to setup BlackBerry Enterprise Service 10 to use static port 1433 on a local Microsoft SQL Server 2008 R2 Express Edition

Article ID: KB35372

Type: Support Content

Last Modified: 11-26-2013

 

Product(s) Affected:

  • BlackBerry Enterprise Service 10
Jump to: Environment | Overview
CollapseEnvironment
  • BlackBerry Enterprise Service 10 version 10.1 and 10.2
  • Microsoft SQL Server 2008 R2 - Express Edition
CollapseOverview

During the installation of BlackBerry Enterprise Service 10, it is possible to install locally and use a Microsoft SQL Server 2008 R2 - Express Edition. By default SQL Express is configured for Dynamic port only.

The setup application configures a Dynamic port automatically for BlackBerry Enterprise Service 10.

If it is required to use a Static port instead of a Dynamic port, proceed with the following steps:

  1. Launch the BlackBerry Enterprise Service 10 setup application and Microsoft SQL Server 2008 R2 Express Edition:
    1. Run the BlackBerry Enterprise Service 10 installer and select Create BlackBerry Enterprise Service Domain > Install and use Microsoft SQL 2008 R2 Express Edition on this computer.
    2. Proceed with the installation until the Microsoft SQL Server database is to be created.
    3. Verify the SQL server name is <host>\BLACKBERRY.
    4. Select the Database name (by default, is BDSMgmt).
    5. Change the Port Configuration setting to Static.
  2. Change Port configuration in Microsoft SQL Server 2008 R2 Express Edition:
    1. Open SQL Server Configuration Manager and select SQL Network Configuration > Protocol for BLACKBERRY.
    2. Select TCP/IP and clear the TCP Dynamic Ports values. 
    3. Set the TCP Port setting to 1433 for all the IP addresses that the server will listen from.
  3. Complete the Installation:
    1. Go back to the BlackBerry Enterprise Service 10 installer screen, and proceed with the Microsoft SQL Server database creation and BES10 setup.

Disclaimer

By downloading, accessing or otherwise using the Knowledge Base documents you agree:

   (a) that the terms of use for the documents found at www.blackberry.com/legal/knowledgebase apply to your use or reference to these documents; and

   (b) not to copy, distribute, disclose or reproduce, in full or in part any of the documents without the express written consent of RIM.


Visit the BlackBerry Technical Solution Center at www.blackberry.com/btsc.