BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 02-28-2009, 08:13 PM   #1 (permalink)
Knows Where the Search Button Is
 
Join Date: Mar 2007
Model: 7100T
Carrier: verizon
Posts: 39
Post Thanks: 0
Thanked 0 Times in 0 Posts
Arrow BES and SQL on SBS 2003

Please Login to Remove!

I've installed a couple of BES's on Windows Small Business Server 2003 and have had the same issue. When the BES install gets to the database phase, it assumes you're going to use the SQL Express install that Small Business Server uses for server reports. It won't offer to install SQL Express at all -which is what I think needs to happen. So I download SQL Express from Microsoft and install it, point the installation at it, and then proceed with the BES install. Is this standard procedure when installing on SBS 2003, or is there something I'm missing? Is there an easier way to do this? Thanks!
Offline  
Old 02-28-2009, 09:05 PM   #2 (permalink)
BlackBerry Elite
 
knottyrope's Avatar
 
Join Date: Jan 2008
Location: Massachusetts
Model: Z30
OS: 10.2.1
PIN: t of blood has been taken
Carrier: AT&T-US with I dee ten tee errors
Posts: 6,697
Post Thanks: 270
Thanked 286 Times in 270 Posts
Default

might help

View Document
__________________
irony : many old timer posters have de-evolved into the trolls they once fought
I am on http://supportforums.blackberry.com
BES 10 running sweet for my Z30, Z10 and Q10
Online  
Old 03-01-2009, 09:29 PM   #3 (permalink)
Knows Where the Search Button Is
 
Join Date: Mar 2007
Model: 7100T
Carrier: verizon
Posts: 39
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

KB 11232 seems to describe what I'm already doing - install a new instance of SQL Express and point BES at it. This seems to be a common situation with SBS 2003. Unlike Backup Exec software, The BES installer isn't clever enough to recognize you already have SQL Express installed and want to make a new named instance for it. If Backup Exec does this, I'm sure it can be done. Considering most of my clients only have ten phones or less and no apps, it seems a waste to install SQL a second time just for BES.
Offline  
Old 03-02-2009, 07:48 AM   #4 (permalink)
BlackBerry Extraordinaire
 
Join Date: Mar 2007
Model: Z10
OS: 10.1.0.19
Carrier: Fido
Posts: 1,068
Post Thanks: 6
Thanked 30 Times in 29 Posts
Default

BES on SBS 2003 using SQL
Offline  
Old 03-02-2009, 08:32 AM   #5 (permalink)
BlackBerry Elite
 
knottyrope's Avatar
 
Join Date: Jan 2008
Location: Massachusetts
Model: Z30
OS: 10.2.1
PIN: t of blood has been taken
Carrier: AT&T-US with I dee ten tee errors
Posts: 6,697
Post Thanks: 270
Thanked 286 Times in 270 Posts
Default

Thats too funny.
__________________
irony : many old timer posters have de-evolved into the trolls they once fought
I am on http://supportforums.blackberry.com
BES 10 running sweet for my Z30, Z10 and Q10
Online  
Old 03-02-2009, 09:53 AM   #6 (permalink)
BlackBerry Extraordinaire
 
Join Date: Mar 2007
Model: Z10
OS: 10.1.0.19
Carrier: Fido
Posts: 1,068
Post Thanks: 6
Thanked 30 Times in 29 Posts
Default

what?
Offline  
Old 03-02-2009, 11:13 AM   #7 (permalink)
Knows Where the Search Button Is
 
Join Date: Mar 2007
Model: 7100T
Carrier: verizon
Posts: 39
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Interestingly enough, SQL Express 2005 is in the Tools folder of the installation folder. I used this rather than download from Microsoft on my last install. Use the default settings and it works.
Offline  
Old 03-02-2009, 11:25 AM   #8 (permalink)
BlackBerry Elite
 
knottyrope's Avatar
 
Join Date: Jan 2008
Location: Massachusetts
Model: Z30
OS: 10.2.1
PIN: t of blood has been taken
Carrier: AT&T-US with I dee ten tee errors
Posts: 6,697
Post Thanks: 270
Thanked 286 Times in 270 Posts
Default

Quote:
Originally Posted by fadmin View Post
what?
the thread you linked, OP was the same user that started this thread.
At first look I almost thought you linked this thread, since it was so similar.
__________________
irony : many old timer posters have de-evolved into the trolls they once fought
I am on http://supportforums.blackberry.com
BES 10 running sweet for my Z30, Z10 and Q10

Last edited by knottyrope : 03-02-2009 at 11:28 AM.
Online  
Old 04-05-2009, 03:07 PM   #9 (permalink)
Thumbs Must Hurt
 
Join Date: Apr 2009
Location: Buckinghamshire, UK
Model: 9800
OS: 6.0.0.246
PIN: 231D8AA4
Carrier: vodafone
Posts: 131
Post Thanks: 20
Thanked 4 Times in 4 Posts
Default

I have had a simlar issue where I have had to download express sql 2005 but once it has all gone through and the database is installed if you ad a new user on and then delete them off it just constantly says pending delete? Any ideas?
Offline  
Old 04-05-2009, 07:38 PM   #10 (permalink)
Knows Where the Search Button Is
 
Join Date: Mar 2007
Model: 7100T
Carrier: verizon
Posts: 39
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

It's hard to tell when BES isn't communicating with the database. You can look in the computer's Application log for Blackbery errors, but I have had to uninstall SQL 2005 Express and reinstall to get things to work. If you only have one license, BES doesn't like it when you delete and add a single user. I would do a complete restart of the server computer just to be on the safe side. Sometimes shutting down and restarting all the Blackberry services and the SQL database by hand works. Turn on SQL first, then all the Blackberry services - no particular order if you're using the latest version of BES. Sometimes only voodoo can get BES to work.
Offline  
Old 04-06-2009, 10:31 AM   #11 (permalink)
BlackBerry Elite
 
knottyrope's Avatar
 
Join Date: Jan 2008
Location: Massachusetts
Model: Z30
OS: 10.2.1
PIN: t of blood has been taken
Carrier: AT&T-US with I dee ten tee errors
Posts: 6,697
Post Thanks: 270
Thanked 286 Times in 270 Posts
Default

try this Just Guessing
View Document
__________________
irony : many old timer posters have de-evolved into the trolls they once fought
I am on http://supportforums.blackberry.com
BES 10 running sweet for my Z30, Z10 and Q10
Online  
Old 04-06-2009, 12:41 PM   #12 (permalink)
Knows Where the Search Button Is
 
Join Date: Mar 2007
Model: 7100T
Carrier: verizon
Posts: 39
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks, Knotty -

I need to check the SQL logs.
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.