BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 10-14-2005, 04:50 AM   #1 (permalink)
New Member
 
Join Date: Oct 2005
Model: 7290
Posts: 2
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default MS SQL Database Creation Problem

Please Login to Remove!

I am trying to set up a new BES 4.0 Server.

Environment setup:
Exchange 2000 running on Windows 2000
BES 4.0 running on windows 2003
MS SQL 2000 runing on same server as BES.

When trying to complete the Blackberry enterprise configuration wizard. I am presented with the following message.

DB Upgrade Failed: Error Executing An SQL Statement.

This occurs whether I am creating a new DB throught the wizard or with a empty DB with the correct account permissions created.

I have followed the Installation guide in the manual and I believe I have set all the required permissions for the windows account and the sql account.

The only part of the SQL installation I am unsure on is whether the server is set to Case-sensitive collation as it was setup as part of an existing application install.

I appreciate any help that can be provided.

Thankyou

Mike Hardman
Offline  
Old 10-14-2005, 05:08 AM   #2 (permalink)
Thumbs Must Hurt
 
Dustbin30's Avatar
 
Join Date: Sep 2005
Location: London
Model: 7230
Posts: 108
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

If you wanna send me the logs I can have a look... got some free time today!!
Offline  
Old 10-14-2005, 05:13 AM   #3 (permalink)
New Member
 
Join Date: Oct 2005
Model: 7290
Posts: 2
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Without sounding stupid, where would i find them.

Mike
Offline  
Old 10-14-2005, 05:27 AM   #4 (permalink)
Thumbs Must Hurt
 
Dustbin30's Avatar
 
Join Date: Sep 2005
Location: London
Model: 7230
Posts: 108
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

the std path would be C:\Program Files\Research In Motion\BES\
Just send the installation.log
Offline  
Old 10-14-2005, 10:05 PM   #5 (permalink)
Talking BlackBerry Encyclopedia
 
Join Date: May 2005
Model: 7100
Carrier: T-Mobile
Posts: 299
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

A case sensitive server collation will cause it to fail. You can check this by right-clicking the SQL Server in Enterprise Manager and selecting Properties.
Offline  
Old 10-15-2005, 01:42 AM   #6 (permalink)
CrackBerry Addict
 
T-Roy's Avatar
 
Join Date: Jan 2005
Model: 8800
Carrier: Darth Vader
Posts: 704
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

installation.log wouldn't have much I expect...
Search for db_install*.log you'll have better luck figuring out what happened with that.
Offline  
Old 10-18-2005, 12:56 PM   #7 (permalink)
dev
CrackBerry Addict
 
dev's Avatar
 
Join Date: Apr 2005
Location: Toronto
Model: 8800
Carrier: Rogers
Posts: 571
Post Thanks: 0
Thanked 2 Times in 2 Posts
Default

That error "DB Upgrade Failed: Error Executing a SQL Statement", usually happens when a database was created using the SQL enterprise manager tool and the wizard is run during the BES install. Delete the db from SQL using the SQL manager, clear/remove the ODBC settings on the BES server and restart the SQL server services.
Re-run the BES install and you should be ok.
Offline  
Old 06-05-2007, 12:33 AM   #8 (permalink)
Knows Where the Search Button Is
 
Join Date: Apr 2006
Location: PA
Model: 9800
Carrier: ATT, Verizon
Posts: 26
Post Thanks: 0
Thanked 0 Times in 0 Posts
Smile

I had the same problem initially but it turned out to be a simple authentication problem. The system I was installing BES on is a domain controller. For some reason the BES setup program did not have the intelligence to add the appropriate sting to the account name. I attempted to connect to the DB as a local user rather than an active directory user. I simply changed the username to "username.doman" rather than just "user" This fixed me right up after I gave the user permission to create and modify databases. I was using MSDE 2000 as the sql backend. I know this thread is pretty much dead but hopefully it will help someone. If this doesn't work, remember to use the search button. There is an unlimited amount of info on this site. Cheers
__________________
Mute... The art of anonymous file sharing. Visit http://mute-net.sourceforge.net
Offline  
Old 08-16-2007, 02:26 PM   #9 (permalink)
Knows Where the Search Button Is
 
Join Date: Jan 2006
Location: Charlotte, NC
Model: Bold
Carrier: AT&T
Posts: 18
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by dev View Post
That error "DB Upgrade Failed: Error Executing a SQL Statement", usually happens when a database was created using the SQL enterprise manager tool and the wizard is run during the BES install. Delete the db from SQL using the SQL manager, clear/remove the ODBC settings on the BES server and restart the SQL server services.
Re-run the BES install and you should be ok.
Wont this break it? Is there more to this?
Offline  
Old 08-16-2007, 02:36 PM   #10 (permalink)
CrackBerry Addict
 
ladydi's Avatar
 
Join Date: Jun 2005
Location: Washington
Model: 8800
Carrier: T-mobile
Posts: 848
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Shouldn't. The BES install will create the DB and set up the connections
__________________
~Di~
Windows 2003
Exchange 2003
BES 4.1
Offline  
Old 08-16-2007, 02:40 PM   #11 (permalink)
Knows Where the Search Button Is
 
Join Date: Jan 2006
Location: Charlotte, NC
Model: Bold
Carrier: AT&T
Posts: 18
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

I am upgrading from 4.0 though.
Offline  
Old 08-16-2007, 08:52 PM   #12 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,632
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

borkap ... what is your question? did you get this error? what version and flavor of BES (including service pack) and DB are you using?
Offline  
Old 09-17-2007, 05:16 PM   #13 (permalink)
New Member
 
Join Date: Sep 2007
Model: 8100
PIN: N/A
Carrier: IT
Posts: 4
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by dev View Post
That error "DB Upgrade Failed: Error Executing a SQL Statement", usually happens when a database was created using the SQL enterprise manager tool and the wizard is run during the BES install. Delete the db from SQL using the SQL manager, clear/remove the ODBC settings on the BES server and restart the SQL server services.
Re-run the BES install and you should be ok.
I have this problem too. I try to run the table.sql script in sql analyzer on the sqlserver, but i see a very lot of error in that. I repair some error (small and big characters...)
But I Don't know wath can I do whit this:
Server: Msg 1776, Level 16, State 1, Line 8
There are no primary or candidate keys in the referenced table 'ServerConfig' that match the referencing column list in the foreign key 'FK_ServerStats_ServerConfig'.
Server: Msg 1750, Level 16, State 1, Line 8
Could not create constraint. See previous errors.
.......

The db creating is runing away to this error message.
Any idea?

Thanking in advance.
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.