BlackBerry® Enterprise Solution

[neeeko]

Hello,

Trying to perform a fresh install on Windows 2008 R2 / SQL 2008R2 Express or SQL 2005 Express. Result : same.

On SQL 2005 or SQL2008R2 (tried both) besadmin has the following roles : dbcreator / serveradmin / sysadmin

Enables TCP/IP, etc...no pb connecting to the DB.

Fact is the BESmgmt has been created but there's a SQL statement that is blocking the rest of the installation.

Among the log lines, here's the interesting part :

[30000] (05/02 11:23:15.943):{0xD4C} SQL being executed:
 
create view dbo.vUserConfigStats as

SELECT     s.MsgsForwarded, s.MsgsSent, s.MsgsPending, s.MsgsExpired, s.MsgsFiltered, s.MsgsFailed, s.Status, s.LastFwdTime, s.LastSentTime,
                      s.LastContactTime, s.LastMsgExpired, s.LastXPAction, sd.ServerTime, sd.ModelName, sd.PlatformVer, sd.AppsVer, sd.PhoneNumber, sd.IMEI,
                      sd.HomeNetwork, sd.VendorID, sd.PasswordEnabled, sd.HandheldConfigStatus, sd.HandheldConfigCheckTime, sd.DCID, sd.FlashSize,
                      sd.ITPolicyName, sd.ITPolicyTime, sd.IMSI, sd.ICCID, sd.ESN, u.*
FROM         dbo.UserConfig u INNER JOIN
             dbo.UserStats s ON u.Id = s.UserConfigId LEFT OUTER JOIN
             dbo.SyncDeviceMgmtSummary sd ON u.Id = sd.UserConfigId
[20000] (05/02 11:23:15.947):{0xD4C} [CBESDBInstaller::executeRetryDDL] COM Error 0x80040E14 - IDispatch error #3092 - Source: "Microsoft OLE DB Provider for SQL Server" - Description "Invalid column name 'IMSI'." Native error = 207
[20000] (05/02 11:23:15.947):{0xD4C} [CBESDBInstaller::executeRetryDDL] COM Error 0x80040E14 - IDispatch error #3092 - Source: "Microsoft OLE DB Provider for SQL Server" - Description "Invalid column name 'ICCID'." Native error = 207
[20000] (05/02 11:23:15.948):{0xD4C} [CBESDBInstaller::executeRetryDDL] COM Error 0x80040E14 - IDispatch error #3092 - Source: "Microsoft OLE DB Provider for SQL Server" - Description "Invalid column name 'ESN'." Native error = 207
[20000] (05/02 11:23:15.948):{0xD4C} [CBESDBInstaller::executeRetryDDL] SQL Error for:

create view dbo.vUserConfigStats as

SELECT     s.MsgsForwarded, s.MsgsSent, s.MsgsPending, s.MsgsExpired, s.MsgsFiltered, s.MsgsFailed, s.Status, s.LastFwdTime, s.LastSentTime,
                      s.LastContactTime, s.LastMsgExpired, s.LastXPAction, sd.ServerTime, sd.ModelName, sd.PlatformVer, sd.AppsVer, sd.PhoneNumber, sd.IMEI,
                      sd.HomeNetwork, sd.VendorID, sd.PasswordEnabled, sd.HandheldConfigStatus, sd.HandheldConfigCheckTime, sd.DCID, sd.FlashSize,
                      sd.ITPolicyName, sd.ITPolicyTime, sd.IMSI, sd.ICCID, sd.ESN, u.*
FROM         dbo.UserConfig u INNER JOIN
             dbo.UserStats s ON u.Id = s.UserConfigId LEFT OUTER JOIN
             dbo.SyncDeviceMgmtSummary sd ON u.Id = sd.UserConfigId
[10000] (05/02 11:23:15.949):{0xD4C} An attempt to install the database was unsuccessful. An error occurred while executing an SQL statement.. Failed to create the database [BESMgmt].

So we have 3 invalid column names...

Been searching.

Any help would be appreciated.

Did restart from scratch several times.

[knottyrope]

Did you let the installer install SQLexpress?

[neeeko]

Yes since it failed with SQL2008R2, i let the BBY installer do the job for SQL2005 Express and i had the same result.

[knottyrope]

is BESAdmin a loacl admin on the server?

I think you might not have permission set correctly

Double check permission according to this

KB02276 - Assigning permissions for a BlackBerry Enterprise Server service account

[neeeko]

Doublechecked it. It has local admin rights.

i should add that we already have another BES server running under Besadmin account without no problem.

[neeeko]

I used createdb.exe as mentioned here :

http://docs.blackberry.com/en/admin/deliverables/25781/Create_empty_BBConfigDB_452488_11.jsp

then restarted the whole isntallation and used the option use an existing Database and voilà !

[knottyrope]

did you create the database on SQL prior to the installation?

just want to see where things might have gone wrong for future reference

[neeeko]

Yes, creating the database first with createdb.exe solved my problem.

[knottyrope]

glad to hear it is working