BlackBerry Forums Support Community               

Closed Thread
LinkBack Thread Tools
Old 05-18-2012, 02:48 PM   #1 (permalink)
Thumbs Must Hurt
jgudnas's Avatar
Join Date: Oct 2006
Location: Calgary
Model: 9800
PIN: where do i find that again.?
Carrier: Rogers
Posts: 71
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Bes install to SQL2012

Please Login to Remove!

setting up a new server in a virtual environment today, to SQL 2012 as the back end (and yes, i know it's not on the compatibility chart yet)

ran into one issue with sql during the install, thought i would share the work-around if anyone else is trying to do the same;

the BES install script uses the sp_dboption stored procedure, which has been depreciated in sql 2012.

so to fix, you have to modify the .sql scripts and replace this command with the appropriate alter database command.
there are 4 instances of this call in the .sql files (i just used grep and replaced them all.. my install files extracted to bes5.0.3Install directory, yours might be different)

C:\bes5.0.3Install\bundle0033\Database\BMS\DBInsta llScripts\SQLServer\1.0\createdb.sql
124 EXEC sp_dboption '_DATABASENAME_', 'recursive triggers', 'FALSE'

C:\bes5.0.3Install\bundle0033\Database\DBInstallSc ripts\SQLServer\createdb.sql
121 EXEC sp_dboption N'_DATABASENAME_', 'recursive triggers', 'FALSE'

C:\bes5.0.3Install\bundle0033\Database\DBInstallSc ripts\SQLServer\createdbDev.sql
41 EXEC sp_dboption '_DATABASENAME_', 'recursive triggers', 'FALSE'

C:\bes5.0.3Install\bundle0033\Database\DBInstallSc ripts\SQLServer\4.1.2\UpgradeV20080410.sql
426 EXEC sp_dboption N'_DATABASENAME_', 'recursive triggers', 'FALSE'

replace each of the above lines with:

save, run through the installer as normal, and use your BES with sql 2012 backend.

800 (direct from RIM), 950, 6280, 7280, 7510, 7520, 7750 (EVIL!!), 7250, 7130e, 8703e, 8100, 8800, 8310, 9000, 9700
Closed Thread

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads for: Bes install to SQL2012
Thread Thread Starter Forum Replies Last Post
How to Fix my BES install... scott0482 BES Admin Corner 2 08-11-2010 11:45 PM
Cannot install Service Pack 7 on BES 4.0 :( premnik BES Admin Corner 3 10-08-2009 01:38 PM
BES for Domino Install Guide / References hdawg BES Admin Corner 18 04-26-2009 01:37 AM
Exchange 2007 BES Install Guide - 100% Fully Functional garycutri BES Admin Corner 0 05-09-2007 01:12 AM
new install BES v4.0 ajaibm BES Admin Corner 2 10-02-2006 04:48 AM

Altair Lighting 3" Recessed Light Kit with Swivel Trim And 50 Watt Bulbs,
Altair Lighting 3MSA 10114835 Rechargeable Altair 5x Air Monitors New In Packaging
MSA 10114835 Rechargeable Altair 5x Air Monitors New In Packaging pictureAltair 4X Multigas Detector ( MSA)
Altair 4X Multigas Detector ( MSA) pictureMSA Altair 5x Multigas Detector O2 CO H2S LEL Pumped P
MSA Altair 5x Multigas Detector O2 CO H2S LEL Pumped   P picture Two MSA Altair 5x Multigas Detectors
 Two  MSA Altair 5x Multigas Detectors picture

Copyright 2004-2016
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.