?
Solved

BES Express 5.0.3 install on SBS2011 - SQL Express 2008 Error

Posted on 2012-03-28
4
Medium Priority
?
1,998 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 17

Assisted Solution

by:WORKS2011
WORKS2011 earned 300 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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

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…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

771 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