|
|
02-04-2008, 05:27 AM
|
#1
|
Thumbs Must Hurt
Join Date: Apr 2006
Location: new york city
Model: 8310
Carrier: AT&T
Posts: 128
|
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
|
|
02-04-2008, 05:33 AM
|
#2
|
BlackBerry Extraordinaire
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
|
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
|
|
02-04-2008, 07:11 AM
|
#3
|
BlackBerry Genius
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,632
|
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
|
|
02-04-2008, 07:30 AM
|
#4
|
Talking BlackBerry Encyclopedia
Join Date: Sep 2007
Location: Belfast
Model: NotYe
PIN: N/A
Carrier: O2
Posts: 470
|
Quote:
Originally Posted by noname
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
|
|
02-04-2008, 07:37 AM
|
#5
|
BlackBerry Genius
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,632
|
Yup, SQL 2005 does this; even Std / Ent. editions with the ".1" stuff for the default instance.
|
Offline
|
|
02-04-2008, 07:39 AM
|
#6
|
Talking BlackBerry Encyclopedia
Join Date: Sep 2007
Location: Belfast
Model: NotYe
PIN: N/A
Carrier: O2
Posts: 470
|
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
|
|
02-04-2008, 11:09 AM
|
#7
|
Thumbs Must Hurt
Join Date: Apr 2006
Location: new york city
Model: 8310
Carrier: AT&T
Posts: 128
|
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
|
|
02-04-2008, 11:37 AM
|
#8
|
BlackBerry Genius
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,632
|
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
|
|
02-05-2008, 04:11 AM
|
#9
|
Thumbs Must Hurt
Join Date: Apr 2006
Location: new york city
Model: 8310
Carrier: AT&T
Posts: 128
|
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
|
|
02-05-2008, 04:36 AM
|
#10
|
Talking BlackBerry Encyclopedia
Join Date: Sep 2007
Location: Belfast
Model: NotYe
PIN: N/A
Carrier: O2
Posts: 470
|
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
|
|
02-05-2008, 05:44 AM
|
#11
|
BBF War Game Mod
Join Date: Oct 2006
Location: Denver CO
Model: Z10
OS: 10010614
PIN: SEEKRIT innit
Carrier: AT&T
Posts: 4,294
|
I might be barking up totally the wrong tree here, but BlackBerry Search Results
__________________
Jadey : Infrastructure Architect, Denver CO
|
Offline
|
|
02-05-2008, 05:50 AM
|
#12
|
BlackBerry Extraordinaire
Join Date: Dec 2007
Model: NA
PIN: 80081ES
Carrier: NA
Posts: 1,006
|
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
|
|
02-06-2008, 03:01 PM
|
#13
|
Thumbs Must Hurt
Join Date: Apr 2005
Location: LI, NY
Model: 8320
OS: 4.5
Carrier: T-Mobile
Posts: 96
|
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
|
|
02-06-2008, 03:02 PM
|
#14
|
Thumbs Must Hurt
Join Date: Apr 2005
Location: LI, NY
Model: 8320
OS: 4.5
Carrier: T-Mobile
Posts: 96
|
And try to point to the server\instance.
__________________
BES 4.1.5
Exchange 2003 SP1
|
Offline
|
|
02-06-2008, 03:16 PM
|
#15
|
CrackBerry Addict
Join Date: Sep 2004
Location: Los Angeles
Model: 9700
Carrier: T-Mobile
Posts: 750
|
You can run SQL 2005 Express with BES 4.1 other than using SQL Enterprise, 2000, and MSDE.
|
Offline
|
|
02-06-2008, 09:45 PM
|
#16
|
Thumbs Must Hurt
Join Date: Dec 2006
Model: 8310
OS: 4.5
Carrier: O2
Posts: 197
|
Quote:
Originally Posted by amukhey
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
|
|
02-07-2008, 03:25 AM
|
#17
|
Talking BlackBerry Encyclopedia
Join Date: Sep 2007
Location: Belfast
Model: NotYe
PIN: N/A
Carrier: O2
Posts: 470
|
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
|
|
02-07-2008, 03:16 PM
|
#18
|
Thumbs Must Hurt
Join Date: Apr 2005
Location: LI, NY
Model: 8320
OS: 4.5
Carrier: T-Mobile
Posts: 96
|
Quote:
Originally Posted by Ugg
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
|
|
|
|