Solved

BES Express 5.0.3 install on SBS2011 - SQL Express 2008 Error

Posted on 2012-03-28
4
1,993 Views
Last Modified: 2012-04-03
Hi all,

Am running through setting up BES Express 5.0.3 on a newly install SB2011 server.

All the pre-checks went well, but it failed to install SQL Express 2005.

Looking through various help topics, it suggested using the install SQL Express 2008 R2.

I stopped the installation and uninstalled SQL Express 2005.

I then ran the CreateDB command in a Administrative command shell from the DES Database folder.

This failed, the error log has the following entry:

30000] (03/28 16:01:23.375):{0x2418} CBESDBInstaller::CBESDBInstaller - working directory is [C:\Data\BESX_5.0.3\BESX_Express_5.0.3\bundle0012\Database]
[30000] (03/28 16:01:23.547):{0x2418} Schema is being installed
[30000] (03/28 16:01:23.547):{0x2418} Scripts loading from: C:\Data\BESX_5.0.3\BESX_Express_5.0.3\bundle0012\Database\DBInstallScripts\SqlServer\
[30000] (03/28 16:01:23.547):{0x2418} Determining progress bar range
[30000] (03/28 16:01:41.617):{0x2418} ADO ConnectionTimeout value = 30s
[30000] (03/28 16:01:41.617):{0x2418} ADO ConnectionTimeout for re-initalizing the pool = 45s
[25137] (03/28 16:02:57.372):{0x2418} {ConnectionItem::ConnectToDB} Failed to connect.  Connection string is Provider=SQLOLEDB.1;Server=localhost;Database=master;Network=dbmssocn;Trusted_Connection=Yes
[25000] (03/28 16:02:57.372):{0x2418} ConnectionItem::ConnectToDB: COM Error 0x80004005 - Unspecified error - Source: "Microsoft OLE DB Provider for SQL Server" - Description "[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied." - Command "ConnectionItem::ConnectToDB"
[20000] (03/28 16:02:57.372):{0x2418} [CBESDBInstaller::Connect] : Pool failed to initialize
====== END OF LOG ======

Not being a SQL person, I'm a bit stumped.
 I can't seem to be able to connect using SQL Management Studio either.
0
Comment
Question by:sp-support
  • 3
4 Comments
 
LVL 17

Assisted Solution

by:WORKS2011
WORKS2011 earned 100 total points
ID: 37778850
are you installing and configuring everything under a BES admin account, it helps if not you end up with permission problems accessing different components of BES and SQL to fail.

I would create the SQL database first, doesn't have to be express do it with SQL Manager Studio then point BES towards it during the install. You can also create the credentials before installing BES which helps whether you use the SA account or Windows account.
0
 

Author Comment

by:sp-support
ID: 37779233
Thanks fro the comments.

I am installing as besadmin, which I have setup as per instructions to give it it's admin privileges.

What I'm not sure about is the how to setup the database, since the dbcreate doesn't work...

How do you create the db and credentials?
0
 

Accepted Solution

by:
sp-support earned 0 total points
ID: 37781671
Well I have finally managed to install BES Express 5.0.3 on our SBS2001 server.

What I did not realise is that you have to run the SQL installer to install a new instance.

I used the SQL Express 2008 R2 installer (SQLEXPRADV_x64_ENU.exe) found in:
C:\Program Files\Windows Small Business Server\Bin\CMPNENTS\SQLEXPRX64RTM

I used this to create a new "BLACKBERRY" instance.

I then used the SQL Server Configuration Manager to enable pipes and TCP/IP connections.

I then added a new rule into the fire ("SQL Server (TCP)") opening port 1433.

I then re-ran the BES installer, it picked up the new BLACKBERRY instance and installation progressed to completion.
0
 

Author Closing Comment

by:sp-support
ID: 37799972
Running through these steps enabled the installation to complete.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Server (2008) Declare Variable (Date) and Set value 6 33
sql help 8 55
How to log the IP address of a failed login attempt 6 39
SQL Server tables join on parse list 6 25
Because virtualization becomes more and more common, and, with Microsoft Hyper-V included in Windows Server at no additional costs, and, most server hardware nowadays is more than capable of running a physical Small Business Server (SBS) 2008 or 201…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question