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

Square D 0/25" 2P Vacuum Sw; 3" On-8" Off OEM 9016GVG1J09
Square D 0/25Bell Gossett Duraire Vacuum Pump V-220
Bell Gossett Duraire Vacuum Pump V-220 picture100% NEW FESTO vacuum generator VADMI-200-LS-P in BOX VADMI200LSP
100% NEW FESTO vacuum generator VADMI-200-LS-P in BOX VADMI200LSP picturePOWERTEC 4 in. Aluminum Blast Gate for Vacuum/Dust Collector
POWERTEC 4 in. Aluminum Blast Gate for Vacuum/Dust Collector pictureWOODS POWR-GRIP 9" VACUUM SUCTION CUP GLASS MIRROR W/METAL CASE -

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