How to configure Microsoft SQL Server Desktop Engine and Microsoft SQL Server for remote use with BlackBerry Manager

Article ID: KB04147

Type: Support Content

Last Modified: 12-14-2011

 

Product(s) Affected:

  • BlackBerry Enterprise Server for Novell GroupWise
  • BlackBerry Enterprise Server for Microsoft Exchange
  • BlackBerry Enterprise Server for IBM Domino
Jump to: Environment | Overview
CollapseEnvironment
  • BlackBerry® Enterprise Server
  • Microsoft® SQL Server® Desktop Engine (MSDE)
  • Microsoft SQL Server 2000, 2005, and 2008
  • BlackBerry Manager
CollapseOverview

To administer the BlackBerry Enterprise Server using Microsoft SQL Server Desktop Engine (MSDE) or Microsoft SQL Server (Express or Full) with a remote installation of BlackBerry Manager, it is required to turn on Named Pipes and Transmission Control Protocol/Internet Protocol (TCP/IP) to allow remote connections.

Before installing BlackBerry Manager on a remote computer, complete the following steps:

  • Install Microsoft Data Access Components (MDAC) 2.8 or later on the remote computer.
  • Run the Microsoft SQL Server Network Utility.

To turn on Named Pipes and TCP/IP, complete the following steps:

For MSDE or Microsoft SQL Server 2000

  1. Go to Start > Run.
  2. Type in CMD and click OK to open a command prompt window.
  3. Type svrnetcn.exe and press ENTER. The Microsoft SQL Server Network Utility screen opens.
  4. Select Named Pipes and click Enable.
  5. Select TCP/IP and click Enable.
  6. Click Apply > OK. The Microsoft SQL Server Network Utility screen closes.
  7. After turning on Named Pipes and TCP/IP, the Microsoft SQL Services must be restarted.

For Microsoft SQL Server 2005 or 2008 Express or Microsoft SQL Server 2005 or 2008

  1. Go to Start > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Configuration Manager > SQL Server 2005 Network Configuration.
  2. Select the Microsoft SQL Server instance that is to be used to house the BlackBerry Configuration Database.
  3. Right-click Named Pipes and select Enable.
  4. Right-click TCP/IP and select Enable.
  5. After turning on Named Pipes and TCP/IP, the Microsoft SQL Server services must be restarted.

For the steps to install BlackBerry Manager on a remote computer, see the appropriate version of the BlackBerry Enterprise Server Administration Guide.

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.