BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 10-31-2007, 08:57 AM   #1 (permalink)
New Member
 
Join Date: Oct 2007
Model: 8820
PIN: N/A
Carrier: Orange
Posts: 3
Post Thanks: 0
Thanked 0 Times in 0 Posts
Unhappy Test database returned unknown error.

Please Login to Remove!

Hi,

I have downloaded BES Express from the Blackberry website and bought myself a blackberry handset with orange. I am led to believe that all blackberry provisions have been catered for. The idea is I trial it for free with my exchange mailbox, and if it works well, I'll roll out a few more.

This is my setup:

SBS 2003 R2 with Exchange SP2, installing BES 4.1.4
I currently have 2 SQL instances running. SBSMONITORING and SHAREPOINT on the SQL Desktop Engine,

This is my problem:

It would appear I am in exactly the same predicament as this guy here:

Test database connection returned an unknown error

Forgive my ignorance but I have virtually no experience with SQL Server and do not know how to create a database to house the blackberry server. I've been on the blackberry website and their written information is either misleading or over complicated. Also, the new flash tutorials neglects showing me how to create the DB.

Last time I installed Sophos SBE, it created and setup the database for me :(

Currently:

I have created the BESAdmin account properly, unpacked and installed BES. It's now at the post-installtion stage and is returning the unknown error when attempting to connect to the SQL database - obviously as it's not there.

Could somebody point me in the right direction? Do I install this by using the DBCreate.exe which resides in the RIM -> Database directory? I've tried this, and it gives me the following error:

GetScriptDir - Scripts loading from: C:\Research in Motion\BlackBerry Enterprise Server 4.1.4\Database\DBInstallScripts\SqlServer\
[20000] (10/31 12:27:21.312):{0x96C} SQL Error Message from CBESDBInstaller::Connect: SQLSTATE: 08001 Native error: 14 Message: [Microsoft][ODBC SQL Server Driver][Shared Memory]Invalid connection.
[30000] (10/31 12:27:21.312):{0x96C} SQL Informational Message from CBESDBInstaller::Connect: [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Invalid Instance()).
[20000] (10/31 12:27:21.312):{0x96C} Terminating because of connection failure. Connect string: DRIVER={SQL Server};SERVER=(local);UID=;PWD*


Any advice much appreciated!
Offline  
Old 10-31-2007, 10:12 AM   #2 (permalink)
New Member
 
Join Date: Oct 2007
Model: 8820
PIN: N/A
Carrier: Orange
Posts: 3
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

FYI: The following is taken directly from the installer log (the one above comes from the SQL log - when I attempt DBCreate).

[30000] (10/31 14:05:38.343):{0x1460} [PIPTOOL]: There are 9047MB space available on the disk of the data directory locates.
[20000] (10/31 14:05:54.233):{0x1460} SQL Error Message from CBESDBInstaller::Connect: SQLSTATE: 08001 Native error: 14 Message: [Microsoft][ODBC SQL Server Driver][Shared Memory]Invalid connection.
[30000] (10/31 14:05:54.233):{0x1460} SQL Informational Message from CBESDBInstaller::Connect: [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Invalid Instance()).
[20000] (10/31 14:05:54.233):{0x1460} Terminating because of connection failure. Connect string: DRIVER={SQL Server};SERVER=SERVER;Trusted_Connection=yes
[20000] (10/31 14:06:09.765):{0x1460} SQL Error Message from CBESDBInstaller::Connect: SQLSTATE: 08001 Native error: 14 Message: [Microsoft][ODBC SQL Server Driver][Shared Memory]Invalid connection.
[30000] (10/31 14:06:09.765):{0x1460} SQL Informational Message from CBESDBInstaller::Connect: [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Invalid Instance()).
[20000] (10/31 14:06:09.765):{0x1460} Terminating because of connection failure. Connect string: DRIVER={SQL Server};SERVER=SERVER;Trusted_Connection=yes
[20000] (10/31 14:06:41.546):{0x1460} COM Error 0x80004005 in ConnectionItem::ConnectToDB() - [DBNETLIB][ConnectionOpen (Invalid Instance()).]Invalid connection. - Unspecified error (connection string - Provider=SQLOLEDB;Server=SERVER;Database=BESMgmt;T rusted_Connection=Yes)
[10000] (10/31 14:06:41.562):{0x1460} [CDBWrapper::ConnectDB]: [DBNETLIB][ConnectionOpen (Invalid Instance()).]Invalid connection.0x80004005 NativeError=14.
Offline  
Old 11-06-2007, 07:41 PM   #3 (permalink)
New Member
 
Join Date: Nov 2007
Model: 8700
PIN: N/A
Carrier: Orange
Posts: 1
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

I too have the same problem and identical error on SBS 2003 SP2 - would love to hear if you got this fixed

Stu
Offline  
Old 11-07-2007, 12:29 AM   #4 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,632
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

You're getting an error:

Invalid Instance

which means the installer cannot located the SQL instance that you have created. You don't need to use dbcreate when you're performing a new installation ... check these:

Cannot install a named MSDE instance for BlackBerry Enterprise Server software version 4.1 and later and How to install the BlackBerry Enterprise Server on a Microsoft Small Business Server
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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On





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