BES Express 5.0.3 install on SBS2011 - SQL Express 2008 Error

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.
sp-supportAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

WORKS2011Austin Tech CompanyCommented:
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
sp-supportAuthor Commented:
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
sp-supportAuthor Commented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sp-supportAuthor Commented:
Running through these steps enabled the installation to complete.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SBS

From novice to tech pro — start learning today.