BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 02-04-2008, 04:27 AM   #1 (permalink)
Thumbs Must Hurt
 
luckman212's Avatar
 
Join Date: Apr 2006
Location: new york city
Model: 8310
Carrier: AT&T
Posts: 128
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Help! Can't install new BES 4.1.4 - SQL error "

Please Login to Remove!

Help, I am trying to install BES 4.1.4 on a Windows 2003 SBS server fully patched. I get up to this step:



I have downloaded the latest SQL Server Express 2005 and ran it with the default install options, during which everything completed successfully and did not indicate any problems. However I cannot get past this stage. I am really desperate, can anyone help me through here? Thanks!

server is "besx_4.1.4.exe" downloaded direct from RIM.
__________________
8310 running 4.2.2.194
Offline  
Old 02-04-2008, 04:33 AM   #2 (permalink)
BlackBerry Extraordinaire
 
noname's Avatar
 
Join Date: Sep 2005
Location: Congested Islet of "Foreign Talents" (> 45% of workforce) - Singapore.
Model: Z10
OS: 10.0.0
PIN: NUKE(PAP)
Carrier: Singtel
Posts: 1,504
Post Thanks: 6
Thanked 9 Times in 9 Posts
Default

Take a closer look at your SQL data and backup paths... "MSSQL.1". You sure you are running default instance?
__________________
Native but 4th class citizen of a nation governed by idiots who import congestions & contention.
Offline  
Old 02-04-2008, 06:11 AM   #3 (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

Is the service SQLSERVER Service started? Can you telnet to SERVER01 at port 1433 and be returned a blank screen with a blinking cursor?
Offline  
Old 02-04-2008, 06:30 AM   #4 (permalink)
Talking BlackBerry Encyclopedia
 
DavidAdams's Avatar
 
Join Date: Sep 2007
Location: Belfast
Model: NotYe
PIN: N/A
Carrier: O2
Posts: 470
Post Thanks: 2
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by noname View Post
Take a closer look at your SQL data and backup paths... "MSSQL.1". You sure you are running default instance?
Same folder structure as i have and i am fairly sure i just accepted the defaults as i went.
__________________
BES, 4.1.7, was SBE now full BES
Domino v7.0.2
Windows Server 2003, standalone
Offline  
Old 02-04-2008, 06:37 AM   #5 (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

Yup, SQL 2005 does this; even Std / Ent. editions with the ".1" stuff for the default instance.
Offline  
Old 02-04-2008, 06:39 AM   #6 (permalink)
Talking BlackBerry Encyclopedia
 
DavidAdams's Avatar
 
Join Date: Sep 2007
Location: Belfast
Model: NotYe
PIN: N/A
Carrier: O2
Posts: 470
Post Thanks: 2
Thanked 0 Times in 0 Posts
Default

i may well be wrong but my memory is prompting me that i needed the machine name as well as the SQL instance, even locally.
__________________
BES, 4.1.7, was SBE now full BES
Domino v7.0.2
Windows Server 2003, standalone
Offline  
Old 02-04-2008, 10:09 AM   #7 (permalink)
Thumbs Must Hurt
 
luckman212's Avatar
 
Join Date: Apr 2006
Location: new york city
Model: 8310
Carrier: AT&T
Posts: 128
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

I am afraid to uninstall/reinstall the SQL server because isn't SQL express used for some SBS2003 native functions? I don't want their server to go down or get its settings screwed up irrevocably because I tried to install the BES.

I checked and yes the SQLEXPRESS service is running. I tried stopping and restarting it, and then opening a TELNET session to localhost:1433 and it says "Connecting To localhost...Could not open connection to the host, on port 1433: Connect failed" so I guess that means its not working? I am dying on the vine here guys is there some tutorial or PDF guide I can follow for installing a BES including the prerequisites?
__________________
8310 running 4.2.2.194
Offline  
Old 02-04-2008, 10:37 AM   #8 (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

from a command prompt:

telnet server01 1433

and then press enter

The screen should go blank and a blinking cursor will appear if you've connected successfully.
Offline  
Old 02-05-2008, 03:11 AM   #9 (permalink)
Thumbs Must Hurt
 
luckman212's Avatar
 
Join Date: Apr 2006
Location: new york city
Model: 8310
Carrier: AT&T
Posts: 128
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

well I can't telnet to the localhost 1433. It seems like the service is running and I see it in services.msc and task manager. How can I troubleshoot this guys? This customer is getting antsy now.
__________________
8310 running 4.2.2.194
Offline  
Old 02-05-2008, 03:36 AM   #10 (permalink)
Talking BlackBerry Encyclopedia
 
DavidAdams's Avatar
 
Join Date: Sep 2007
Location: Belfast
Model: NotYe
PIN: N/A
Carrier: O2
Posts: 470
Post Thanks: 2
Thanked 0 Times in 0 Posts
Default

Comparing the screen shots i am guessing the machine is SERVER01, and the SQL instance is SQLEXPRESS, try SERVER01\SQLEXPRESS in the database field, may not work i am no expert but it is ringing very faint bells from my own install a few months ago.
__________________
BES, 4.1.7, was SBE now full BES
Domino v7.0.2
Windows Server 2003, standalone
Offline  
Old 02-05-2008, 04:44 AM   #11 (permalink)
BBF War Game Mod
 
Jadey's Avatar
 
Join Date: Oct 2006
Location: Denver CO
Model: Z10
OS: 10010614
PIN: SEEKRIT innit
Carrier: AT&T
Posts: 4,294
Post Thanks: 9
Thanked 29 Times in 23 Posts
Default

I might be barking up totally the wrong tree here, but BlackBerry Search Results
__________________
Jadey : Groupware Infrastructure Architect, Denver CO
If I'm not here, I'm playing World's End on FaceBook. Mob/Mafia Wars are SOO last year
Offline  
Old 02-05-2008, 04:50 AM   #12 (permalink)
BlackBerry Extraordinaire
 
gibson_hg's Avatar
 
Join Date: Dec 2007
Model: NA
PIN: 80081ES
Carrier: NA
Posts: 1,006
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

I think that David got it, the default instance of MS SQL Server 2005 Express is called SQLEXPRESS. The name is listed in the Services, also, there are 3 sqlserver.exe's running. If there is only one SQL instance then it should be called SQLEXPRESS. Every instance has a name and they will be listed in the Services screen. Try telnet server01\SQLEXPRESS 1433, and try using that as your DB server in the installation.
Offline  
Old 02-06-2008, 02:01 PM   #13 (permalink)
Thumbs Must Hurt
 
Join Date: Apr 2005
Location: LI, NY
Model: 8320
OS: 4.5
Carrier: T-Mobile
Posts: 96
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

I don't think you can use SQL 2005 Express with 4.1. If I am not mistaking you have to use MSDE or SQL 2000, 2005 not Express.
__________________
BES 4.1.5
Exchange 2003 SP1
Offline  
Old 02-06-2008, 02:02 PM   #14 (permalink)
Thumbs Must Hurt
 
Join Date: Apr 2005
Location: LI, NY
Model: 8320
OS: 4.5
Carrier: T-Mobile
Posts: 96
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

And try to point to the server\instance.
__________________
BES 4.1.5
Exchange 2003 SP1
Offline  
Old 02-06-2008, 02:16 PM   #15 (permalink)
CrackBerry Addict
 
amukhey's Avatar
 
Join Date: Sep 2004
Location: Los Angeles
Model: 9700
Carrier: T-Mobile
Posts: 750
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

You can run SQL 2005 Express with BES 4.1 other than using SQL Enterprise, 2000, and MSDE.
Offline  
Old 02-06-2008, 08:45 PM   #16 (permalink)
Ugg
Thumbs Must Hurt
 
Join Date: Dec 2006
Model: 8310
OS: 4.5
Carrier: O2
Posts: 197
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by amukhey View Post
You can run SQL 2005 Express with BES 4.1 other than using SQL Enterprise, 2000, and MSDE.
I thought that it didn't work with MDS Services, though? Not that we know that luckman212 selected "with MDS Services" as the install type, of course - if not, it's not an issue.

Maybe I'm missing something here, but I'm not sure why an extra install of SQL 2005 Express was needed. Any reason that the built-in MSDE 2000 in SBS 2003 wouldn't have done the job? Could that be what's causing the unusual SQL instance path? I'd have expected "C:\Program Files\Microsoft SQL Server\MSSQL\Data" myself. The .1, .2 and .3 directories exist, but (on a non SBS server) seem to contain stuff for the OLAP and other new stuff that's part of 2005.
Offline  
Old 02-07-2008, 02:25 AM   #17 (permalink)
Talking BlackBerry Encyclopedia
 
DavidAdams's Avatar
 
Join Date: Sep 2007
Location: Belfast
Model: NotYe
PIN: N/A
Carrier: O2
Posts: 470
Post Thanks: 2
Thanked 0 Times in 0 Posts
Default

i am running BES on SQL Express 2005, same box as the BES, and i have the .1 path same as the OP, in the .1 folder i have a MSSQL folder. This is on a standard 2003 server.
__________________
BES, 4.1.7, was SBE now full BES
Domino v7.0.2
Windows Server 2003, standalone
Offline  
Old 02-07-2008, 02:16 PM   #18 (permalink)
Thumbs Must Hurt
 
Join Date: Apr 2005
Location: LI, NY
Model: 8320
OS: 4.5
Carrier: T-Mobile
Posts: 96
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by Ugg View Post
I thought that it didn't work with MDS Services, though? Not that we know that luckman212 selected "with MDS Services" as the install type, of course - if not, it's not an issue.

Maybe I'm missing something here, but I'm not sure why an extra install of SQL 2005 Express was needed. Any reason that the built-in MSDE 2000 in SBS 2003 wouldn't have done the job? Could that be what's causing the unusual SQL instance path? I'd have expected "C:\Program Files\Microsoft SQL Server\MSSQL\Data" myself. The .1, .2 and .3 directories exist, but (on a non SBS server) seem to contain stuff for the OLAP and other new stuff that's part of 2005.
My mistake, MDS Services doesn't work with SQL Express.
__________________
BES 4.1.5
Exchange 2003 SP1
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.