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





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