Solved

BES Express 5.0.3 install on SBS2011 - SQL Express 2008 Error

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

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Format Date fields 11 54
SQL QUERY 3 41
SQL- GROUP BY 4 44
Complex SQL Server WHERE CLause 9 34
I work for a company that primarily works with small businesses as their outsourced IT vendor. As such the majority of these customers utilize some version of Small Business Server. Due to the economics of running a small business, many of these cus…
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…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

734 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