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.

inside custom component

BlackBerry® Enterprise Service 10

Reply
Highlighted
New Contributor
Posts: 3
Registered: ‎12-28-2010
My Device: Not Specified

SQL Server Connectivity Issues

Good Afternoon,

 

We are running BES 5.0 Express on a Windows 2003 Server. The Management Database is on a separate machine also running Windows 2003 Server and SQL Server 2005 SP3.

 

We've noticed we are receiving a lot of Warnings in the Event Log and MAGT log file directory stating connectivity issues, however we are able to connect to SQL fine:

 

 

[25137] (12/28 12:57:40.649):{0x1368} {ConnectionItem::ConnectToDB} Failed to connect.  Connection string is Provider=SQLNCLI.1;Server=SQLMACHINE,1433;Database=BESMgmt;Network=dbmssocn;Trusted_Connection=Yes
[25000] (12/28 12:57:40.664):{0x1368} ConnectionItem::ConnectToDB: COM Error 0x80004005 - Unspecified error - Source: "Microsoft SQL Native Client" - Description "TCP Provider: Timeout error [258]. " - Command "ConnectionItem::ConnectToDB"
[20000] (12/28 12:57:40.664):{0x1368} ConnectionPool::GetConnection(): Unable to get connection, because the Connection pool is uninitialized
[20402] (12/28 12:57:40.664):{0x1368} BESDBImp::GetReloadUser: Unable to find available connection
[20402] (12/28 12:57:40.664):{0x1368} BESDBImp::GetClearInCradle: Unable to find available connection
[20402] (12/28 12:57:40.664):{0x1368} BESDBImp::GetCalSlowSync: Unable to find available connection
[20624] (12/28 12:57:40.664):{0x1368} SCS:Smiley TongueerformDBHealthCheck: GetStyleSheetFromDB failed

 

[25137] (12/28 12:57:40.649):{0x1368} {ConnectionItem::ConnectToDB} Failed to connect.  Connection string is Provider=SQLNCLI.1;Server=SQLMACHINE,1433;Database=BESMgmt;Network=dbmssocn;Trusted_Connection=Yes[25000] (12/28 12:57:40.664):{0x1368} ConnectionItem::ConnectToDB: COM Error 0x80004005 - Unspecified error - Source: "Microsoft SQL Native Client" - Description "TCP Provider: Timeout error [258]. " - Command "ConnectionItem::ConnectToDB"[20000] (12/28 12:57:40.664):{0x1368} ConnectionPool::GetConnection(): Unable to get connection, because the Connection pool is uninitialized[20402] (12/28 12:57:40.664):{0x1368} BESDBImp::GetReloadUser: Unable to find available connection[20402] (12/28 12:57:40.664):{0x1368} BESDBImp::GetClearInCradle: Unable to find available connection[20402] (12/28 12:57:40.664):{0x1368} BESDBImp::GetCalSlowSync: Unable to find available connection[20624] (12/28 12:57:40.664):{0x1368} SCS:Smiley TongueerformDBHealthCheck: GetStyleSheetFromDB failed

 

When this happens apparentely messages fail to reconcile and appear correctly on the device. I've checked the SQL error logs, there are no errors, furthermore I have monitoring on port 1433 and the monitoring reports no failure. Other services (i.e. a website) also work fine, it just seems to be BES which can't connect.

 

The SQL Browser service is running on the SQL machine.

 

I'm not sure where to go next with this problem but any help appreciated!

 

 

 

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

I'm rockin the BlackBerry PRIV, 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: SQL Server Connectivity Issues

IPV6 enabled? turn it off on the NIC
Receive Side Scaling (RSS)
http://support.microsoft.com/kb/951037

 




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


New Contributor
Posts: 3
Registered: ‎12-28-2010
My Device: Not Specified

Re: SQL Server Connectivity Issues

Hi,

 

Thank you for your response - much appreciated.

 

The machine isn't running IPv6 - it's also running Windows 2003 Enterprise rather than Windows 2008.

 

M

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

I'm rockin the BlackBerry PRIV, 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: SQL Server Connectivity Issues

I would look into networking more.

 

Using broadcom NIC? they have a slew of issues with QOS.

 

Using windows firewall on the server?

 

can you copy a large file from SQL to your BES server wtih no issue?

 




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