Welcome!

Welcome to the official BlackBerry Support Community Forums.

This is your resource to discuss support topics with your peers, and learn from each other.

Reply
Highlighted
New Contributor
Posts: 2
Registered: ‎12-30-2013
My Device: Z10
My Carrier: O2
Accepted Solution

BES fails to find SQL DB after reboot

Hey Guys, i have looked around but cannot seem to find any help with this one.

We have a BES express server runnings on its own box, the SQL database is sitting on a second Main server.

We did a reboot of our main server following some maintance and now the BES dispatcher will not start.

Using the Server configuration tool the Test SQL server connection fails with unable to find SQL server.

 

I have tried restarting services and even both servers but no joy. Both servers can see and ping eachother.

Im getting several Errors in event logs for Dispatcher but this is the one with most information :

ConnectionItem::ConnectToDB: COM Error 0x80004005 - Unspecified error - Source: "Microsoft OLE DB Provider for SQL Server" - Description "[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied." - Command "ConnectionItem::ConnectToDB"

 

Many thanks

New Contributor
Posts: 2
Registered: ‎12-30-2013
My Device: Z10
My Carrier: O2

Re: BES fails to find SQL DB after reboot

So it turns out that after a reboot a port went for a walk.

Just had to open a port on the main server firewall that was hosting SQL and eveything came back to life.

 

Firewall had an open port for BES but seemed to need a second one for SQL.

 

Guru III
Posts: 32,190
Registered: ‎06-25-2008
My Device:

I'm rockin the BlackBerry DTEK60, Passport, Z30, Z10, Q10, BlackBerry Mini Stereo Speaker, 64 gig PlayBook,BT Headset HS-700

My Carrier: I am on AT&T. Please edit your Personal Profile with your DEVICE TYPE, DEVICE OS and Carrier

Re: BES fails to find SQL DB after reboot

thanks for sharing your solution with us

 

 




Click here to Backup the data on your BlackBerry Device! It's important, and FREE!


Click "Accept as Solution" if your problem is solved. To give thanks, click thumbs up
Click to search the Knowledge Base at BTSC and click to Read The Fabulous Manuals

BESAdmin's, please make a signature with your BES environment info.


SIM Free BlackBerry Unlocking FAQ
Follow me on Twitter @knottyrope


Want to thank me? Buy my KnottyRope App here


BES 12 and BES 5.0.4 with Exchange 2010 and SQL 2012 Hyper V