BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 02-04-2008, 05: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, 05: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, 07: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, 07: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, 07: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, 07: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, 11: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, 11: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, 04: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, 04: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, 05: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, 05: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, 03: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, 03: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, 03: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, 09: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, 03: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, 03: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  




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