[Malkier]

Details:

BES 4.1.3
Exchange 2007
SQL2005 Database

Attempting to install Service Pack 4 and receiving the following error. No luck with RIM so far. Anyone have an idea at all of what it means,cause/fix?
Any information at all would be greatly appreciated!

[20000] (01/24 14:57:06.665):{0xF58} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42S02 Native error: 208 Message: Invalid object name 'DBAMonitor..DDLSecurityLog'.
[30000] (01/24 14:58:10.302):{0xF58} [PIPTOOL]: Exiting PIPTool from DBInfoDlg.

[hdawg]

Which service pack of SQL 2005 are you using?

Have you restored from a previous SQL backup and tried again, generating the same error?

[mahoward]

This may be a longshot, but is your database set to case insensitive collation? If it is case sensitive it may not find the table it is looking for b/c the capitalization is off. What you want to see is "CI" somewhere in the collation settings (i.e. sort order rules) on the DB, like this:

[Malkier]

The SQL version is SQL 2005 SP2 (Refresh - pre GDR)

The collation is case insensitive (SQL_Latin1_General_CP1_CI_AS).

No luck as of yet, Thanks for the suggestions so far, greatly appreciatated.
At a loss atm, guess I will give RIM a third shot at this one....

One other message that keeps showing up in the logs, is that a problem (sorry dont know SQL well)

[30000] (01/18 13:48:23.947):{0xD48} SQL Informational Message from CBESDBInstaller::Connect: Changed database context to 'BESMgmt'.

[Malkier]

Dont know if it helps, but this is where the install was upto when it fails.

-- deny the following groups write access to security objects (not currently used)
deny insert, delete, update on SecGroup to rim_db_bes_server, rim_db_admin_enterprise, rim_db_admin_handheld, rim_db_admin_sr_helpdesk, rim_db_admin_jr_helpdesk
deny insert, delete, update on SecUser to rim_db_bes_server, rim_db_admin_enterprise, rim_db_admin_handheld, rim_db_admin_sr_helpdesk, rim_db_admin_jr_helpdesk
deny insert, delete, update on SecMapping to rim_db_bes_server, rim_db_admin_enterprise, rim_db_admin_handheld, rim_db_admin_sr_helpdesk, rim_db_admin_jr_helpdesk