BlackBerry Enterprise Server installation will not complete when using Microsoft SQL Server 2012

Article ID: KB31728

Type: Support Content

Last Modified: 01-16-2014

 

Product(s) Affected:

  • BlackBerry Enterprise Server
  • BlackBerry Enterprise Server for Microsoft Exchange
  • BlackBerry Enterprise Server for IBM Domino
  • BlackBerry Enterprise Server for Novell GroupWise
  • BlackBerry Enterprise Server Express for Microsoft Exchange
  • BlackBerry Enterprise Server Express for IBM Domino
CollapseEnvironment
  • BlackBerry Enterprise Server 5.0 to 5.0 SP3
  • Microsoft SQL Server 2012
  • DT 2496874
CollapseOverview

When performing a new installation of BlackBerry Enterprise Server using Microsoft SQL 2012, the following error is displayed :

An attempt to install the database was unsuccessful. An error occurred while executing an SQL statement.

Note: This issue only affects installations where a new database is being created. Upgrading an existing installation of BlackBerry Enterprise Server or migrating an existing BlackBerry configuration database to Microsoft SQL Server 2012 are supported, and should complete successfully.

CollapseCause
The BlackBerry Enterprise Server installer requires certain stored procedures which are no longer available in Microsoft SQL Server 2012. As a result, the installation will not complete.
CollapseResolution

The issue is resolved in BlackBerry Enterprise Server 5.0 SP4.

CollapseWorkaround
Install BlackBerry Enterprise Server using Microsoft SQL Server 2008 or earlier. Once installation is completed, migrate the BlackBerry configuration database to Microsoft SQL Server 2012.

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.