View Single Post
Old 05-18-2012, 02:48 PM   #1 (permalink)
jgudnas
Thumbs Must Hurt
 
jgudnas's Avatar
 
Join Date: Oct 2006
Location: Calgary
Model: 9800
OS: 6.0.0.161
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:
alter database "_DATABASENAME_" set RECURSIVE_TRIGGERS OFF

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

Cheers.
__________________
800 (direct from RIM), 950, 6280, 7280, 7510, 7520, 7750 (EVIL!!), 7250, 7130e, 8703e, 8100, 8800, 8310, 9000, 9700
Offline   Reply With Quote