BlackBerry Forums Support Community
              

Closed Thread
 
Thread Tools
Old 07-17-2008, 10:22 AM   #1
TroyB
Thumbs Must Hurt
 
Join Date: Jul 2005
Model: 8700
Carrier: Cingular
Posts: 64
Default Issues connecting fresh BES install to remote SQL2005 DB?

Please Login to Remove!

I hate feeling like such a newbie. Sorry for all the dumb qustions lately. Here's my latest:

I'm trying to do a 100% fresh install of BES and connect it to a remote SQL2005 Server DB. It goes through the install juat fine, it even creates the database, but after that I get the following errors in the DB_Install log file and it aborts saying that an error occured while trying to execute and SQL statement:

[20000] (07/17 10:08:59.228):{0xD0C} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42S22 Native error: 207 Message: Invalid column name 'RouterLinkStatus'.
[20000] (07/17 10:08:59.228):{0xD0C} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42S22 Native error: 207 Message: Invalid column name 'MsgsExpired'.
[20000] (07/17 10:08:59.228):{0xD0C} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42S22 Native error: 207 Message: Invalid column name 'MsgsFiltered'.
[20000] (07/17 10:08:59.228):{0xD0C} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42S22 Native error: 207 Message: Invalid column name 'MsgsForwarded'.
[20000] (07/17 10:08:59.228):{0xD0C} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42S22 Native error: 207 Message: Invalid column name 'MsgsPending'.
[20000] (07/17 10:08:59.228):{0xD0C} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42S22 Native error: 207 Message: Invalid column name 'MsgsSent'.


Any help?
Offline  
Old 07-17-2008, 11:56 AM   #2
fadmin
BlackBerry Extraordinaire
 
Join Date: Mar 2007
Model: Z10
OS: 10.1.0.19
Carrier: Fido
Posts: 1,068
Default

Have you gone through these?:
BlackBerry Search Results
Offline  
Old 07-17-2008, 02:50 PM   #3
TroyB
Thumbs Must Hurt
 
Join Date: Jul 2005
Model: 8700
Carrier: Cingular
Posts: 64
Default

Wow. Nice work! It was Casue 4. The account I was using wasn't assigned the System Administrator role.

Thanks a million for the assist!
Offline  
Closed Thread



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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


Tektronix 7904 Oscilloscope Mainframe  w/ 2x 7A26 2x 7B92A Modules picture

Tektronix 7904 Oscilloscope Mainframe w/ 2x 7A26 2x 7B92A Modules

$399.97



Chroma 6312 DC Electronic Load Mainframe  picture

Chroma 6312 DC Electronic Load Mainframe

$239.96



Tektronix TM506 Modular 6-bay Mainframe Compartment for power 6-Slot READ DESCRP picture

Tektronix TM506 Modular 6-bay Mainframe Compartment for power 6-Slot READ DESCRP

$124.95



Tektronix TM515 5-Bay Traveler Mainframe for TM5000 Series System, Tested Good picture

Tektronix TM515 5-Bay Traveler Mainframe for TM5000 Series System, Tested Good

$199.99



ILX Lightwave LDC3908 Laser Diode Controller Mainframe with Key picture

ILX Lightwave LDC3908 Laser Diode Controller Mainframe with Key

$480.00



Lug-All 4000-20 Medium Frame Cable Ratchet Winch Pulley Hoist New in Box 2 Ton picture

Lug-All 4000-20 Medium Frame Cable Ratchet Winch Pulley Hoist New in Box 2 Ton

$355.00







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