BlackBerry Forums Support Community
              

Closed Thread
 
LinkBack Thread Tools
Old 01-17-2009, 05:48 PM   #1 (permalink)
New Member
 
Join Date: Jan 2009
Model: 8830
PIN: N/A
Carrier: MTS
Posts: 2
Post Thanks: 0
Thanked 0 Times in 0 Posts
Unhappy Problem installing Blackberry Professional Software, SQL error

Please Login to Remove!

Hi all.

I'm trying to install the BPS on my Small Business Server 2003 at work using the built in Exchange 2003 (SP2).

I've created the besadmin account, followed the directions, done the reboot, now when it asks about Database Settings, I get the following error.
"An attempt to upgrade the Database was unsuccessful. An error occured while executing an SQL statement."
All the info on the DB setup screen got left at default, local database, the server name was auto populated as were the DB name and port. The authentication mode is windows trusted.

I've verified that SQL service is running in the system tray (green play button). I've checked the SQL logs, and this is the last entry in there.

Quote:
20000] (01/17 16:37:10.937):{0x1134} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42S22 Native error: 207 Message: Invalid column name 'RouterLinkStatus'.
[20000] (01/17 16:37:10.937):{0x1134} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42S22 Native error: 207 Message: Invalid column name 'MsgsExpired'.
[20000] (01/17 16:37:10.937):{0x1134} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42S22 Native error: 207 Message: Invalid column name 'MsgsFiltered'.
[20000] (01/17 16:37:10.937):{0x1134} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42S22 Native error: 207 Message: Invalid column name 'MsgsForwarded'.
[20000] (01/17 16:37:10.937):{0x1134} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42S22 Native error: 207 Message: Invalid column name 'MsgsPending'.
[20000] (01/17 16:37:10.937):{0x1134} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42S22 Native error: 207 Message: Invalid column name 'MsgsSent'.
I've done some searching but can only find info pertaining to when upgrading from a previous version of BES or BPS, not on a new install. I've tried changing the name of the DB from BESMgmt to BESMgmt1.

Does anyone have any suggestions on what to try? I'm pretty new to anything SQL related, so I haven't done any troubleshooting on that front because I don't have a clue where to start on that front.

Thanks for any help
Offline  
Old 01-17-2009, 07:15 PM   #2 (permalink)
New Member
 
Join Date: Jan 2009
Model: 8830
PIN: N/A
Carrier: MTS
Posts: 2
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Never mind, I got it figured out. The DB setup screen was pointing to servername, not servername\sql instance. Changing that worked, now I just need to get 3101 open so I can validate the SRP key.
Offline  
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

B&R AUTOMATION 8V1180.00-2 ACOPOS 1180 SERVO DRIVE REV N0 D573710
$700.0
B&R AUTOMATION 8V1180.00-2 ACOPOS 1180 SERVO DRIVE REV N0 D573710 pictureSignal corp. I-177 Tube Tester Amplifier test control switch Tested p.
$14.99
Signal corp.  I-177 Tube Tester Amplifier test  control switch Tested   p. picture15W Button Control MP3 Amplifier Board Module Stable For SPIFLASH TF Card U-Disk
$5.29
15W Button Control MP3 Amplifier Board Module Stable For SPIFLASH TF Card U-Disk pictureAmpliwave solid state RF power amplifier AW900-40. u.s.a. nice condition.
$279.0
Ampliwave solid state RF power amplifier AW900-40. u.s.a. nice condition. pictureCD01M Power Op Amp Amplifier TO-3-8
$37.49
CD01M Power Op Amp Amplifier TO-3-8 picture






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