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


OEM IBM Wheelwriter Easystrike High Yield Correctable Film Ribbons 1299845 picture

OEM IBM Wheelwriter Easystrike High Yield Correctable Film Ribbons 1299845

$17.00



IBM Correctable Ribbon Cassette Black 1299300 NOS Original OEM picture

IBM Correctable Ribbon Cassette Black 1299300 NOS Original OEM

$2.99



Genuine IBM Selectrric Motor Bushing 10 Pack OEM  P/N 1236572 picture

Genuine IBM Selectrric Motor Bushing 10 Pack OEM P/N 1236572

$7.99



IBM CASH DRAWER KEY'S #9960 SET OF 2 KEYS. AFTERMARKET KEY'S SAME AS OEM 33G3360 picture

IBM CASH DRAWER KEY'S #9960 SET OF 2 KEYS. AFTERMARKET KEY'S SAME AS OEM 33G3360

$18.00



IBM Genuine OEM Printer Filler Wide Credit Card Holder 10N1259 picture

IBM Genuine OEM Printer Filler Wide Credit Card Holder 10N1259

$24.79



OEM  IBM Type 5441 WheelWriter 3 1356658 1362400-02 Main Boards Tested Working picture

OEM IBM Type 5441 WheelWriter 3 1356658 1362400-02 Main Boards Tested Working

$34.99







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