sp-support
asked on
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::CBESDBIns taller - working directory is [C:\Data\BESX_5.0.3\BESX_E xpress_5.0 .3\bundle0 012\Databa se]
[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_Ex press_5.0. 3\bundle00 12\Databas e\DBInstal lScripts\S qlServer\
[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::ConnectTo DB} Failed to connect. Connection string is Provider=SQLOLEDB.1;Server =localhost ;Database= master;Net work=dbmss ocn;Truste d_Connecti on=Yes
[25000] (03/28 16:02:57.372):{0x2418} ConnectionItem::ConnectToD B: 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::ConnectTo DB"
[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.
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::CBESDBIns
[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_Ex
[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::ConnectTo
[25000] (03/28 16:02:57.372):{0x2418} ConnectionItem::ConnectToD
[20000] (03/28 16:02:57.372):{0x2418} [CBESDBInstaller::Connect]
====== 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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Running through these steps enabled the installation to complete.
ASKER
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?