SQL Server 2008 Connection Refused - Blackberry Enterprise Server Express

LyonJay
LyonJay used Ask the Experts™
on
Dear all,

I am currently having a issue with my Blackberry server connecting to the SQL Server 2008.

I have rebuilt the Windows Server itsself incase there was any outstanding issues with it but I still can't get it to communicate with the SQL Server.

Everytime I try and get the Blackberry Server to communicate with the SQL Server I get the following error:

[30000] (08/07 17:21:16.771):{0xA20} <6>Aug 07 17:21:16 TCT-BES-01  {0x874} 1142: (#45060) {ConnectionPool::ValidatePool}: Pool is not initialized
[30000] (08/07 17:21:16.771):{0xA20} <6>Aug 07 17:21:16 TCT-BES-01  {0x874} 1143: (#45060) {ConnectionPool::ValidatePool}: Pool is not initialized
[30000] (08/07 17:21:17.380):{0xA20} <5>Aug 07 17:21:17 TCT-BES-01  {0x874} 1144: (#30000) ADO ConnectionTimeout value = 30s
[30000] (08/07 17:21:17.380):{0xA20} <5>Aug 07 17:21:17 TCT-BES-01  {0x874} 1145: (#30000) ADO ConnectionTimeout for re-initalizing the pool = 45s
[30000] (08/07 17:21:48.828):{0xA20} <4>Aug 07 17:21:48 TCT-BES-01  {0x874} 1146: (#25137) {ConnectionItem::ConnectToDB} Failed to connect.  Connection string is Provider=SQLOLEDB.1;Server=TCT-SQL-01\MSSQLSERVER;Database=master;Network=dbmssocn;Trusted_Connection=Yes
[30000] (08/07 17:21:48.828):{0xA20} <4>Aug 07 17:21:48 TCT-BES-01  {0x874} 1147: (#25000) ConnectionItem::ConnectToDB: COM Error 0x80004005 - Unspecified error - Source: "Microsoft OLE DB Provider for SQL Server" - Description "[DBNETLIB][ConnectionOpen (ParseConnectParams()).]Invalid connection." - Command "ConnectionItem::ConnectToDB"

Also when I try and create a new ODBC connector to the SQL Server I get the following error:

Microsoft SQL Server ODBC Driver Version 06.01.7601

Running connectivity tests...

Attempting connection
[Microsoft][ODBC SQL Server Driver]Cannot generate SSPI context

TESTS FAILED!


Any one got any ideas how to fix this?

Thanks,

Lyon!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Hello,

From the box where you are trying to connect to sql server (assuming these are two different) can you give following command to check to see if it is connectible at all using windows authentication.

osql -STCT-SQL-01\MSSQLSERVER -E

Author

Commented:
Where shall I put that command in? Cmd?
Yes, please.
Commented:
Hi,

Have you added the BlackBerry Service account login to the SQL Server Security -> Logins?

Is remote TCP Connectivity enabled?

Regards,


RobMobility.

Author

Commented:
Hey!

Turns out to be the fact that the AD user account had multiple other selections on it such as other encryption etc. Put the account back to default and it came back to life.

Thank you all for your help!

LyonJT
I am having the same issues.  

My situation is slightly different.  I am running Server 2008 x64 servers, on the domain.  BES 5.0.3 (not BES express) and SQL Server 2008.  The first part of my install runs fine, then reboots and when prompted to input SQL information, I am unable to connect to the instance and/or create a DB.  The errors I receive are:

{ConnectionItem::ConnectToDB} Failed to connect.  Connection string is Provider=SQLOLEDB.1;Server=sql2008server,1433;Database=master;Network=dbmssocn;Trusted_Connection=Yes
 ConnectionItem::ConnectToDB: COM Error 0x80004005 - Unspecified error - Source: "Microsoft OLE DB Provider for SQL Server" - Description "Cannot generate SSPI context" - Command "ConnectionItem::ConnectToDB"
 ADO ConnectionTimeout value = 30s
 ConnectionTimeout for re-initalizing the pool = 45s
 {ConnectionItem::ConnectToDB} Failed to connect.  Connection string is Provider=SQLOLEDB.1;Server=sql2008server,1433;Database=BESMgmt;Network=dbmssocn;Trusted_Connection=Yes
 ConnectionItem::ConnectToDB: COM Error 0x80004005 - Unspecified error - Source: "Microsoft OLE DB Provider for SQL Server" - Description "Cannot generate SSPI context" - Command "ConnectionItem::ConnectToDB"
 An attempt to connect the database was unsuccessful. Refer to the installation log file for more information.


I have tried every combination of windows vs. sql authentication; dynamic vs. static ports; backing up vs. not backing up the db prior to install; 2 different service accounts; I've actually created a BESMgmt DB on the SQL server and it still could not point to it and connect.  I've given both svc accounts DB Creator, Sysadmin and serveradmin SQL rights, and they both have more than enough juice as far as AD premissions go.  the same service accounts are actively running our existing BES infrastructure on other servers.  We are attempting to create a parallel BB Domain, then migrate users from the older, crippled one, to the new one.  

On the SQL Server, Named Pipes and TCP/IP connections are enabled for this instance.  I attempted to run the OSQL cmd noted earlier in this post, but received cmd not recognized errors when I attempted to run it from the BlackBerry Server.  

Any assistance will be extremely appreciated!

- James
I have tried to use the CreateDB.exe tool and modified the BESMgmt.cfg to have all of the proper credentials for my environment and it also failed.  Here is an excerpt from the CreateDB.exe log:

[30000] (02/10 10:06:49.416):{0x434} CBESDBInstaller::CBESDBInstaller - working directory is [C:\Users\513besadmin\Desktop\Database]
[30000] (02/10 10:06:50.747):{0x434} Schema is being installed
[30000] (02/10 10:06:50.747):{0x434} Scripts loading from: C:\Users\513besadmin\Desktop\Database\DBInstallScripts\SqlServer\
[30000] (02/10 10:06:50.747):{0x434} Determining progress bar range
[30000] (02/10 10:07:12.092):{0x434} ADO ConnectionTimeout value = 30s
[30000] (02/10 10:07:12.092):{0x434} ADO ConnectionTimeout for re-initalizing the pool = 45s
[25137] (02/10 10:07:42.633):{0x434} {ConnectionItem::ConnectToDB} Failed to connect.  Connection string is Provider=SQLOLEDB.1;Server=GORD14QA505\MSSQLSERVER;Database=master;Network=dbmssocn;Trusted_Connection=Yes
[25000] (02/10 10:07:42.634):{0x434} ConnectionItem::ConnectToDB: COM Error 0x80004005 - Unspecified error - Source: "Microsoft OLE DB Provider for SQL Server" - Description "[DBNETLIB][ConnectionOpen (ParseConnectParams()).]Invalid connection." - Command "ConnectionItem::ConnectToDB"
[20000] (02/10 10:07:42.644):{0x434} [CBESDBInstaller::Connect] : Pool failed to initialize

I ran CreateDB on both the server I am installing BES on, and the SQL server itself.  Both times had the same result.  

So far, BB Tech support has advised me to verify that my SQL Services are running an to make sure that TCP/IP, Shared Memory and Named pipes are enabled... which they are.  

Thanks,

James
Did you find a solution, got the same problem ... regards
Not for this issue.  We deleted the VM SQL server and cloned a new one, then re-installed SQL.  It worked from that point forward.  

Sorry I don't have a better answer for you.  We were spending too much time troubleshooting it and not getting anywhere.  

James
ok.. thanks, at this office we only have 2 servers... SBS 2003 and Terminal 2003, we have uninstalled BES 4.1 for installing BESx 5 but there is a problem with the SQL server software that refuse connection. I have tried many many things. If somebody can help.... i would appreciate

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial