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
Contributor
Posts: 16
Registered: ‎09-17-2009
My Device: Not Specified

Bes Terminating.. Can't connect to SQL

Hello..

I keep getting this error...

 

09/17/2009 04:07:06 PM  Unable to open BESMgmt database: Login failed for user ' (null)'. Reason: Not associated with a trusted SQL Server connection.0x80004005 NativeError=184520x80004005 NativeError=100540x80004005 NativeError=10054Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.0x80004005 NativeError=184520x80004005 NativeError=100540x80004005 NativeError=10054Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.0x800
09/17/2009 04:07:06 PM  Error initialising BES. Terminating.

 

Sounds like a authentication issue, so I went to the BB server config and check the connection info to the external SQL server.

It're correct and it tests fine.

 

So I looked thru a forum (not here), and it was mentioned about manually entering in a login / pwd in the registry, which I did, but errors still occur.

HKLM\software\Research in Motion\Blackberry Enterprise Server\database

sting values added.

Login

Password

 

 

Can anyone  help? (btw this subject is not in this v5.0 forum that I can find)

 

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 Terminating.. Can't connect to SQL

I think the test is only to connect to the SQL server.

 

Did you assign the SQL permissions on the BESMGMT database as well.

 

 




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


Contributor
Posts: 16
Registered: ‎09-17-2009
My Device: Not Specified

Re: Bes Terminating.. Can't connect to SQL

 

Yes, I even created a seperate account and and assigned it to there.

(both machines are in the same domain)

I even tried the sql SA account...

Same error.

 

Looks like I'm having to redo this thing with a local SQL install.

darnit..

 

also under blackberry router tab SRP Address field.. what do i put here?

No matter what address I specify it comes back connection refused.....

 

Heading home.

long day....

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 Terminating.. Can't connect to SQL


bflagg wrote:

 

Yes, I even created a seperate account and and assigned it to there.

(both machines are in the same domain)

I even tried the sql SA account...

Same error.

Did you check the SQL logs? They can help trouble shoot too.

 

 

Looks like I'm having to redo this thing with a local SQL install.

darnit..

 

also under blackberry router tab SRP Address field.. what do i put here?

No matter what address I specify it comes back connection refused.....

Did you get your firewall set for port 3101 yet?

 

Heading home.

long day....


 

 




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


Contributor
Posts: 16
Registered: ‎09-17-2009
My Device: Not Specified

Re: Bes Terminating.. Can't connect to SQL

Server logs revealed nothing of note.

BUT.. the Network Admin made a mistake and port 3101 was not open.

 

I did a clean server redo ( 4th time now) and now I can connect to a local SQLExpress install, and I can connect to BB on port 3101, but now the webadmin service will not run. So now I cannot administer the install.

 

In the last install with all the errors, I could, now reinstalling clean (using the exact same settings) I can't.

 

I'm going nuts!!!!!!!! Smiley Happy

Highlighted
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 Terminating.. Can't connect to SQL

All it takes is one little thing to not make it work.

Hang in there sounds like you are making progress.

 

Have you checked the BAS logs for logon issues.

 




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