BlackBerry Forums Support Community
              

Closed Thread
 
LinkBack Thread Tools
Old 10-25-2010, 08:34 AM   #1 (permalink)
New Member
 
Join Date: Oct 2010
Model: Admin
PIN: N/A
Carrier: Verizon
Posts: 2
Post Thanks: 0
Thanked 0 Times in 0 Posts
Exclamation BES 5.1 SQL Connection Problem

Please Login to Remove!

Hi all, first post, though I have browsed here quite a bit.

A couple of months ago we installed BES 5.1, with very little struggle. But the database was installed to an existing instance of MSSQL 2005, created by our backup software, Symantec Backup Exec.

We replaced Backup Exec with Acronis B&R for SBS, and uninstalled Backup Exec.

Backup exec deleted it's instance of the MSSQL server, and took the BES DB with it, taking down our BES in the process.

I pulled up a recent backup in a VM, exported the BES DB, and restored it to a new instance of SQL, but now trying to reinstall BES it cannot access the Database, reporting "An attempt to connect to the database was unsuccessful. Refer to the installation log file for more information"

The .log file in C:\Program Files\Research In Motion\BlackBerry Enterprise Server\Logs\Installer says the following (Edited to remove identifying data)

[30000] (10/25 09:11:50.906):{0x245C} <5>Oct 25 09:11:50 MYSERVER {0x23D0} 0175: (#30000) ADO ConnectionTimeout value = 30s
[30000] (10/25 09:11:50.906):{0x245C} <5>Oct 25 09:11:50 MYSERVER {0x23D0} 0176: (#30000) ADO ConnectionTimeout for re-initalizing the pool = 45s
[30000] (10/25 09:12:23.531):{0x245C} <4>Oct 25 09:12:23 MYSERVER {0x23D0} 0177: (#25137) {ConnectionItem::ConnectToDB} Failed to connect. Connection string is Provider=SQLOLEDB.1;Server=MYSERVER\MYDB;Database= BESMgmt;Network=dbmssocn;Trusted_Connection=Yes
[30000] (10/25 09:12:23.531):{0x245C} <4>Oct 25 09:12:23 MYSERVER {0x23D0} 0178: (#25000) ConnectionItem::ConnectToDB: COM Error 0x80004005 - Unspecified error - Source: "Microsoft OLE DB Provider for SQL Server" - Description "[DBNETLIB][ConnectionOpen (Connect()).]Specified SQL server not found." - Command "ConnectionItem::ConnectToDB"
[30000] (10/25 09:12:23.531):{0x245C} <4>Oct 25 09:12:23 MYSERVER {0x23D0} 0179: (#25105) Failed to authenticate connection - local machine time may be out of sync with domain controller time. Please restart Windows Time Service.
[30000] (10/25 09:12:23.531):{0x245C} <3>Oct 25 09:12:23 MYSERVER {0x23D0} 0180: (#10000) An attempt to connect the database was unsuccessful. Refer to the installation log file for more information.
[30000] (10/25 09:12:35.953):{0x245C} <6>Oct 25 09:12:35 MYSERVER {0x23D0} 0181: (#45060) {ConnectionPool::ValidatePool}: Pool is not initialized
[30000] (10/25 09:12:35.953):{0x245C} <6>Oct 25 09:12:35 MYSERVER {0x23D0} 0182: (#40000) [PIPTOOL]: Applied dynamic SQL port values.
Offline  
Old 10-25-2010, 10:01 AM   #2 (permalink)
New Member
 
Join Date: Oct 2010
Model: Admin
PIN: N/A
Carrier: Verizon
Posts: 2
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Turns out, Named pipes and TCP were disabled. I quick looked and saw them in the SQL Configuration and figured they were there and all was well, later looked to the right and saw them disabled, enabled them and we were good to go.

Thanks anyway!
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

NEW VESA ADAPTER PLATE FOR DELL E-SERIES MONITORS - OEM
$9.99
NEW VESA ADAPTER PLATE FOR DELL E-SERIES MONITORS - OEM pictureGenuine OEM New Open Box Dell G20VW Magenta Toner Cartridge; E525 Series
$39.98
Genuine OEM New Open Box Dell G20VW Magenta Toner Cartridge; E525 Series pictureDELL 725-10263 / 331-1310 / KT74N Lamp manufactured by DELL
$216.18
DELL 725-10263 / 331-1310 / KT74N Lamp manufactured by DELL pictureOriginal Chunghwa 15" CLAA150XP01QL A+ LCD Screen Display OEM Dell E157FPTe
$45.0
Original Chunghwa 15OEM BULB with Housing for DELL KT74N Projector with 180 Day Warranty
$149.0
OEM BULB with Housing for DELL KT74N Projector with 180 Day Warranty picture






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