There are a lot of errors in Event viewer, most of them are SQL errors. Here's some (one per line):
CheckDB: COM exception.
COM Error 0x45ADF0 in CheckDB - Type name is invalid. - IDispatch error #3120
Database error in CheckDB (err=0x80040E30, native err=0) - Type name is invalid.
PMDatabaseSQLImp::CheckDB: COM Error 0x80040E30 - IDispatch error #3120 - Source: "Microsoft OLE DB Provider for SQL Server" - Description "Type name is invalid." - Command ""
[Microsoft][ODBC SQL Server Driver]Optional feature not implemented[SqlState HYC00][ODBCRecord::bindWhereCols]Error executing SQLBindParameter
[Microsoft][ODBC SQL Server Driver]COUNT field incorrect[SqlState 07002][ODBCRecord::DoGetMultiValue]Error executing SQL statement "SELECT UserConfigId, Id, ObjectDefnId, ConfigId, Operation, Details FROM ServerConfigHistory WHERE ServerConfigId = ? AND Id > ? AND (ObjectDefnId = ? OR (ObjectDefnId = ? AND Operation = ?) OR (ObjectDefnId = ? AND Operation = ?)) ORDER BY UserConfigId, Id DESC" DATA: ServerConfigId[1] Id[0] ObjectDefnId[200] ObjectDefnId[300] Operation[U] ObjectDefnId[310] Operation[D].
Our setup is BES 4.0 and Exchange 2000 enterprise. SQL and Exchange are on separate servers. Among these server can't connect to SRP and BB's can't activate wirelessly (emails are coming to mailboxes but BB server doesn't process them. I gave all SQL permissions to BB user I could.
I'm not really BB wise but I readed all the threads from here and can't find any similar issue :(
Ok, finally got it running by installing MSSQL locally. But my boss wants all databases on 1 server. These errors are happening only when using remote SQL. Anyone knows how to fix them? All configuration is correct, the server has around 5 active DBs which are working perfectly.
Most likely you didn't have your permissions correctly setup. I would definately reread the howto's here and instructions step-by-step on setting up remote databases.