Solved

BES Express 5.0.3 install on SBS2011 - SQL Express 2008 Error

Posted on 2012-03-28
4
1,992 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

[Webinar] Disaster Recovery and Cloud Management

Learn from Unigma and CloudBerry industry veterans which providers are best for certain use cases and how to lower cloud costs, how to grow your Managed Services practice in IaaS clouds, and how to utilize public cloud for Disaster Recovery

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Square brackets 4 38
SQL compatability in SQL 2016 2 31
Server Backup on 2016 Essentials Box 1 38
Getting same value for every field in SQL 2 27
You may have discovered the 'Compatibility View Settings' workaround for making your SBS 2008 Remote Web Workplace 'connect to a computer' section stops 'working around' after a Windows 10 client upgrade.  That can be fixed so it 'works around' agai…
A quick step-by-step overview of installing and configuring Carbonite Server Backup.
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

910 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now