SQL Error on BESX 5.0.2 Installation

[Naman]

Hello,

We have a Windows 2008 R2 with SQL2008(not R2) and Exch2010 Sp1 installed.

I tried to install BlackBerry Enterprise Server Express 5.0.2 but it stops everytime with the following error in the Install.Log file:


30000] (12/10 13:09:38.285):{0x39FC} SQL being executed:

/*
* Create the ServerConfig table if it doesn't already exist.
*/
IF NOT EXISTS (SELECT name FROM sysobjects WHERE name = 'ServerConfig' AND type = 'U')
begin
CREATE TABLE dbo.ServerConfig
(
Id int IDENTITY (1,1) NOT FOR REPLICATION NOT NULL,
ServiceName nvarchar(256),
DisplayName nvarchar(256),
ServerDN ntext NOT NULL DEFAULT '',
MachineName nvarchar(256) NOT NULL DEFAULT '',
MailServerName nvarchar(256) NOT NULL DEFAULT '',
MailStoreType nvarchar(64) not null
CONSTRAINT CK_ServerConfig_MailStoreType CHECK
(MailStoreType = 'Exchange' or MailStoreType = 'Notes' or MailStoreType = 'GroupWise'),
LinkStatus int DEFAULT 0,
SRPHostName nvarchar(256) NOT NULL DEFAULT '',
SRPid nvarchar(256) NOT NULL DEFAULT '',
SRPKey char(49),
SRPPort int not null DEFAULT 3101

[20000] (12/10 13:09:38.298):{0x39FC} [CBESDBInstaller::executeRetryDDL] COM Error 0x80040E14 - IDispatch error #3092 - Source: "Microsoft OLE DB Provider for SQL Server" - Description "Column name 'id' does not exist in the target table or view." Native error = 1911
[20000] (12/10 13:09:38.298):{0x39FC} [CBESDBInstaller::executeRetryDDL] COM Error 0x80040E14 - IDispatch error #3092 - Source: "Microsoft OLE DB Provider for SQL Server" - Description "Could not create constraint. See previous errors." Native error = 1750
[20000] (12/10 13:09:38.298):{0x39FC} [CBESDBInstaller::executeRetryDDL] SQL Error for:

/*
* Create the ServerConfig table if it doesn't already exist.
*/
IF NOT EXISTS (SELECT name FROM sysobjects WHERE name = 'ServerConfig' AND type = 'U')
begin
CREATE TABLE dbo.ServerConfig
(
Id int IDENTITY (1,1) NOT FOR REPLICATION NOT NULL,
ServiceName nvarchar(256),
DisplayName nvarchar(256),
ServerDN ntext NOT NULL DEFAULT '',
MachineName nvarchar(256) NOT NULL DEFAULT '',
MailServerName nvarchar(256) NOT NULL DEFAULT '',
MailStoreType nvarchar(64) not null
CONSTRAINT CK_ServerConfig_MailStoreType CHECK
(MailStoreType = 'Exchange' or MailStoreType = 'Notes' or MailStoreType = 'GroupWise'),
LinkStatus int DEFAULT 0,
SRPHostName nvarchar(256) NOT NULL DEFAULT '',
SRPid nvarchar(256) NOT NULL DEFAULT '',
SRPKey char(49),
SRPPort in
[10000] (12/10 13:09:38.298):{0x39FC} An attempt to install the database was unsuccessful. An error occurred while executing an SQL statement.. Failed to create the database [BESMgmt].


Can anyone help me with this?

Thank You

[kbartlett]

[10000] (12/10 13:09:38.298):{0x39FC} An attempt to install the database was unsuccessful. An error occurred while executing an SQL statement.. Failed to create the database [BESMgmt].

If the BESMgmt database is on a remote SQL server, first make sure that the account that you are using for the installation has the appropriate SQL roles assigned to it on that back-end server. (DB_Owner, DB_Creator, DB_ServerAccess and SA (probably)). Based on that last error line, it sounds like it might not.

[knottyrope]

make sure you enable TCP/IP , named pipes and SQL browser is running.