BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 04-05-2011, 01:16 PM   #1 (permalink)
New Member
 
Join Date: Apr 2011
Model: 9800
PIN: N/A
Carrier: fido
Posts: 2
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default BES Express SQL installation problem

Please Login to Remove!

I am trying to install BES X 5.0.2 ( Bundle 14 ) on Windows 2008 R2 with Exchange 2010 SP1 ( non-hosting mode ). Everything runs on the same server.

I am hitting a brick wall in getting BES X to use the SQL Express 2005 installation we have. I have followed all the instructions available on the Blackberry Website, including the video but I can't get it to connect to SQL. My last steps were:

1. Created a BLACKBERRY instance under SQL Express 2005

2. Using the Management Studio I can login to that instance from within the Administrator account. I added user 'besadmin' as allowed to connect there too

3. Using the Management Studio I can login to that instance from within the 'besadmin' account. In Management Studio I simply connect to: EXCH1\BLACKBERRY using Windows Authentication and I'm in!

4. Continuing the BES X installation ( after restart ) I have to enter the SQL details. I enter the same thing: EXCH1\BLACKBERRY , point the data directory & backup to the proper places. When I hit 'Next' it takes a loooong time and comes back with: An attempt to connect the database was unsuccesfull. Refer to the installation log file for more information.

The log file contains:

[30000] (04/05 13:18:02.297):{0x1D2C} <4>Apr 05 13:18:02 exch1 {0x1C80} 1679: (#25137) {ConnectionItem::ConnectToDB} Failed to connect. Connection string is Provider=SQLOLEDB.1;Server=EXCH1\BLACKBERRY;Databa se=BESmgmt;Network=dbmssocn;Trusted_Connection=Yes

[30000] (04/05 13:18:02.297):{0x1D2C} <4>Apr 05 13:18:02 exch1 {0x1C80} 1680: (#25000) ConnectionItem::ConnectToDB: COM Error 0x80004005 - Unspecified error - Source: "Microsoft OLE DB Provider for SQL Server" - Description "Microsoft OLE DB Provider for SQL Server" - Command "ConnectionItem::ConnectToDB"

[30000] (04/05 13:18:02.297):{0x1D2C} <3>Apr 05 13:18:02 exch1 {0x1C80} 1681: (#10000) [CDBComp::Connect]: Cannot connect to DB with error: [DBNETLIB][ConnectionOpen (Connect()).]Specified SQL server not found.0x80004005 NativeError=6

[30000] (04/05 13:18:02.897):{0x1D2C} <5>Apr 05 13:18:02 exch1 {0x1C80} 1682: (#30000) ADO ConnectionTimeout value = 30s

[30000] (04/05 13:18:02.897):{0x1D2C} <5>Apr 05 13:18:02 exch1 {0x1C80} 1683: (#30000) ADO ConnectionTimeout for re-initalizing the pool = 45s

Please note that EXCH1 points to 127.0.0.1. I don't think that matters since Management Studio connects just fine to EXCH1\BLACKBERRY

Any ideas ?
Offline  
Old 04-05-2011, 01:53 PM   #2 (permalink)
New Member
 
Join Date: Apr 2011
Model: 9800
PIN: N/A
Carrier: fido
Posts: 2
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Re: BES Express SQL installation problem

Fixed the issue by enabling Named Pipes in SQL Server 2005:

Go to Start > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Configuration Manager > SQL Server 2005 Network Configuration.
Select the Microsoft SQL server instance that houses the BlackBerry Configuration Database.
Right click on Named Pipes and select Enable.
Right click on TCP/IP and select Enable.
If you enabled a protocol in step c, restart the Microsoft SQL Services.

It's very strange that Management Studio could connect without Named Pipes enabled but BES X could not.
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

Similar Threads for: BES Express SQL installation problem
Thread Thread Starter Forum Replies Last Post
BES 4.1 Upgrade to 5.0.2 with SQL Mirroring (parallel with Ex2003 to Ex2010 upgrade) Jay247 BES Admin Corner 4 11-21-2010 09:05 AM
Demo Installation of BES Express imranshabbir General BlackBerry Discussion 0 05-26-2010 01:28 AM
Problem with BES Manager connecting to SQL Database Zeeman28a BES Admin Corner 2 09-04-2009 10:59 AM
BES Express installation problem edmund.lin BES Admin Corner 1 12-14-2007 08:23 AM
BES Service Account and SQL Confusion cwood BES Admin Corner 3 03-31-2006 04:50 PM





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