Hi BES gurus. I have hit the wall with a new BES 4.0.2 install on Win2k. I have done a few BES installs in the past, including an upgrade from 3.6 to 4.0, and had success. So I'm not a complete newbie. But this one has me stumped.
Environment:
BES Server: Win2k SP4 running SQL2000 SP3a
Exchange Server: New machine running SBS2003 SP1 with Exchange 2003SP1.
The BES install is a downloaded package supplied by my client's vendor (Telstra AU).
I have followed the install guide to prepare the environment, so I have a BESAdmin account created with all of the rights and permissions configured as per the guide. My CDO.dll is Version 6.5.7226.0. with the Exch2k3 System Manager installed on the Win2k box (even though I am fairly certain that CDO.dll versions would not be causing the problem I am having).
When I run the BES install (as BESAdmin), and choose to install the Enterprise Server, everything runs OK, and I reboot. Login as BESAdmin and let the Config utility start, and it comes up with the SQL details page. SQL server name is entered with the default DB name "BESMgmt". Click Next and it says the DB doesn't exist and asks if I want to create it, Click Yes. System chugs at it for a minute and then throws back an error dialog that reads as follows:
"DB Upgrade failed. Error executing an SQL Statement."
Only option is to click OK which returns me to the DB config screen. Click Next again and I get a message saying "Database already exists, refer to database log file for more information. Either delete the database or manually update it."
I have deleted and attempted to re-create the DB numerous times. And I have un-installed and re-installed the BES software a few times as well. I have tried Windows auth for SQL, as well as SQL auth. Text of the DB log file is as follows:
[30000] (01/17 16:18:00):{0x600} Current Date: 2006/01/17
[30000] (01/17 16:18:00):{0x600} [DIAG] EVENT=Thread_report, THREADID=0x600, THREADNAME="DebugLogger"
[40000] (01/17 16:18:00):{0x774} [ODBCDatabase] DB=SQL Server, MaxConnection=20, MinConnection=4
[30000] (01/17 16:18:00):{0x774} SQL Informational Message from CBESDBInstaller::Connect: Changed database context to 'master'.
[30000] (01/17 16:18:00):{0x774} SQL Informational Message from CBESDBInstaller::Connect: Changed language setting to us_english.
[30000] (01/17 16:18:00):{0x774} SQL Informational Message from CBESDBInstaller::GetDBVersionForSQLServer.executeu se: Changed database context to 'BESMgmt'.
[30000] (01/17 16:18:00):{0x774} SQL Informational Message from CBESDBInstaller::GetDBVersionForSQLServer.execute: Invalid object name 'ServerDBVersion'.
[30000] (01/17 16:18:00):{0x774} SQL Informational Message from CBESDBInstaller::GetDBVersionForSQLServer.executeu se: Changed database context to 'BESMgmt'.
[30000] (01/17 16:18:00):{0x774} SQL Informational Message from CBESDBInstaller::GetDBVersionForSQLServer.execute: Invalid object name 'ServerDBVersion'.
[30000] (01/17 16:18:00):{0x774} SQL Informational Message from CBESDBInstaller::Connect: Changed database context to 'BESMgmt'.
[30000] (01/17 16:18:00):{0x774} SQL Informational Message from CBESDBInstaller::Connect: Changed language setting to us_english.
[30000] (01/17 16:18:00):{0x774} Processing file tables.sql
[30000] (01/17 16:18:00):{0x774} SQL being executed:
/************************************************** **************************
tables.sql
This SQL script will create the initial BlackBerry Admin Server tables.
Notes:
(C) 1997-2004 Research In Motion Limited.
************************************************** **************************/
/*
* Switch to the BESMgmt database
*/
USE "BESMgmt"
[30000] (01/17 16:18:00):{0x774} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: Changed database context to 'BESMgmt'.
[30000] (01/17 16:18:00):{0x774} SQL executed successfully
[30000] (01/17 16:18:00):{0x774} SQL being executed:
set nocount on
[30000] (01/17 16:18:00):{0x774} SQL executed successfully
[30000] (01/17 16:18:00):{0x774} SQL being executed:
/*
* Create the ITPolicy2 table if it doesn't already exist, otherwise convert existing to new
*/
IF NOT EXISTS (SELECT name FROM sysobjects WHERE name = 'ITPolicy2' AND type = 'U')
begin
CREATE TABLE dbo.ITPolicy2
(
Id int IDENTITY (1,1) NOT NULL,
PolicyName varchar(128) not null,
AllowOtherEmailServices int not null default(1),
AllowOtherBrowserServices int not null default(1),
HandheldBlob image,
DesktopBlob image,
SessionId int null,
Lurnum timestamp not null
)
alter table ITPolicy2 add
CONSTRAINT IX_ITPolicy2_PolicyName UNIQUE CLUSTERED (PolicyName),
CONSTRAINT ITPolicy2_PK PRIMARY KEY (Id)
end
[30000] (01/17 16:18:00):{0x774} SQL executed successfully
[30000] (01/17 16:18:00):{0x774} SQL being executed:
/*
* add default policy
*/
if not exists (select PolicyName from itpolicy2 where PolicyName = 'Default')
begin
insert into itpolicy2 (PolicyName, HandheldBlob)
values ('Default', 0x050744656661756c7401)
end
[10000] (01/17 16:18:00):{0x774} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42S02 Native error: 208 Message: Invalid object name 'itpolicy2'.
====== END OF LOG ======
I am not a DBA, and know little of SQL or it's commands, so this is pretty much unreadable for me.
The config never progresses past this point leaving me pretty much stuck with an unconfigured BES server.
If anyone has any idea what is causing this, and how to get around it, can you please let me know.
Cheers,
Chris.