BlackBerry Forums Support Community
              

Closed Thread
 
Thread Tools
Old 09-14-2005, 08:18 AM   #1
daddy
New Member
 
Join Date: Sep 2005
Model: 8100
Carrier: at&t
Posts: 8
Default Help with BES installation

Please Login to Remove!

Hi there.

I'm trying to get BES running for the 6th day.

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 :(

Last edited by daddy; 09-14-2005 at 08:21 AM..
Offline  
Old 09-14-2005, 08:46 AM   #2
BES-HH
Knows Where the Search Button Is
 
Join Date: Aug 2005
Location: Germany
Model: 9000
Carrier: T-Mobile
Posts: 39
Default

You have to check the DB-Connection to SQL!
All you need is in the installation guide.
Offline  
Old 09-14-2005, 08:55 AM   #3
daddy
New Member
 
Join Date: Sep 2005
Model: 8100
Carrier: at&t
Posts: 8
Default

The DB connection works good. Both via "Test DB connection" and when doing all over again it creates tables successfully.
Offline  
Old 09-14-2005, 10:54 AM   #4
daddy
New Member
 
Join Date: Sep 2005
Model: 8100
Carrier: at&t
Posts: 8
Default

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.
Offline  
Old 09-14-2005, 10:56 AM   #5
bfrye
BBF Veteran User
 
Join Date: Aug 2004
Location: Hotwiring another Cessna
Model: OU812
Carrier: Nintendo
Posts: 3,492
Default

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.
Offline  
Old 09-16-2005, 10:13 AM   #6
daddy
New Member
 
Join Date: Sep 2005
Model: 8100
Carrier: at&t
Posts: 8
Default

The only thing that was wrong is that we had SQL server agent service stopped on SQL server. Ran it and everything seems to be good now

PS - local MSDE crashed next morning and couldn't be started again.
Offline  
Old 09-16-2005, 12:42 PM   #7
jibi
BlackBerry God
 
jibi's Avatar
 
Join Date: Oct 2004
Location: Jibi's Secret Place
Model: 8900
OS: 4.6.1.174
Carrier: AT&T
Posts: 11,310
Default

server can't connect to SRP... hmm.
__________________
In the beginning the Universe was created. This has made a lot of people very angry and is widely regarded as a bad move.
Offline  
Closed Thread


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


Agilent E8403A VXI Mainframe + E8491B, E4808A, 7x E8461B Modules with WARRANTY picture

Agilent E8403A VXI Mainframe + E8491B, E4808A, 7x E8461B Modules with WARRANTY

$3900.00



TEKTRONIX TM5006A 6 BAY MAINFRAME.  (chassis Mainframe only) picture

TEKTRONIX TM5006A 6 BAY MAINFRAME. (chassis Mainframe only)

$200.00



HP 3488A HPIB Switch / Control Unit Mainframe picture

HP 3488A HPIB Switch / Control Unit Mainframe

$24.99



Tektronix TM5003 Power Module Mainframe Chassis picture

Tektronix TM5003 Power Module Mainframe Chassis

$225.00



Agilent HP E8404A VXI Mainframe C-Size, 13 Slot 1000W w/E491B, E1472X2 UNTESTED picture

Agilent HP E8404A VXI Mainframe C-Size, 13 Slot 1000W w/E491B, E1472X2 UNTESTED

$499.99



Computer Conversions Corp. Main Frame Board RTSS-4 picture

Computer Conversions Corp. Main Frame Board RTSS-4

$375.00







Copyright © 2004-2016 BlackBerryForums.com.
The names RIM © and BlackBerry © are registered Trademarks of BlackBerry Inc.