Solved

BlackBerry Enterprise Server Express v5.0.4

Posted on 2013-01-08
14
744 Views
Last Modified: 2013-04-12
BlackBerry Enterprise Server Express v5.0.4

I have just setup and installed a new SQL Server.

I have relocated the Database & Log onto the new SQL Server
(Using the Detach and Attach Method)

I have run the BES software again on the Blackberry server and changed the SQL Name

BES
When Selecting next I get the following error

BES
Advise would be great.
0
Comment
Question by:Bransby-IT
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
14 Comments
 
LVL 3

Author Comment

by:Bransby-IT
ID: 38755447
This is the first SQL Database on the new SQL Server.

I have checked that TCP is enabled and it is.
0
 
LVL 25

Assisted Solution

by:RobMobility
RobMobility earned 167 total points
ID: 38755651
Hi,

Make sure that no firewall is blocking SQL traffic into the new SQL server.

In addition, make sure it's configured to accept connections from external hosts - some SQL versions default to disabled.

Regards,


RobMobility.
0
 
LVL 3

Author Comment

by:Bransby-IT
ID: 38755672
No firewall on the server.

In addition, make sure it's configured to accept connections from external hosts - some SQL versions default to disabled.

Where do I do this?

I have just pushed the database back onto my old server and this started pushing out email straight away.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 25

Expert Comment

by:RobMobility
ID: 38755754
Hi,

If you are using something like SQL Express, some versions limit you to local connections.

It used to be the SQL Surface Area Configuration > Surface Area Configuration for Services and Connections

You needed to configure local and remote connections under the Remote Connections options.

Regards,


RobMobility.
0
 
LVL 25

Expert Comment

by:RobMobility
ID: 38755757
Hi,

Don't forget to set permissions on the database on the new server for your Windows user as well?

Regards,


RobMobility.
0
 
LVL 25

Expert Comment

by:RobMobility
ID: 38755764
0
 
LVL 3

Author Comment

by:Bransby-IT
ID: 38759893
Hi Rob, I have already gone through this and all is well.  
I did recheck a few minuites ago.

I now have other database across onto my SQL server so I know this is up and running.

I have racked my brains.
0
 
LVL 25

Expert Comment

by:RobMobility
ID: 38759930
Hi,

Can you telnet from the BES to the DB box on port 1433?

Regards,


RobMobility
0
 
LVL 3

Author Comment

by:Bransby-IT
ID: 38814799
I will chaeck now.
0
 
LVL 25

Expert Comment

by:RobMobility
ID: 38814855
Just another thought - do you need to specify instance name and database name?

Regards,


RobMobility.
0
 
LVL 3

Author Comment

by:Bransby-IT
ID: 38880674
Still looking into this.
0
 
LVL 3

Author Comment

by:Bransby-IT
ID: 38913461
Still looking into this.
0
 
LVL 3

Assisted Solution

by:Damian Pippet
Damian Pippet earned 166 total points
ID: 39003405
Normally, when I am doing this, I will allow the BES to create a new database, and then restore the database over that one.
If you:
Backup the database through SQL
Run the BES setup
Create the new database

and when the setup has completed

Shutdown all of the BES services
Perform a SQL restore of the database from the backup made earlier (making sure that it is restored into the database that was specified during the setup)

That should do the job for you.
0
 
LVL 4

Accepted Solution

by:
bewaarse earned 167 total points
ID: 39038080
Hi,
    Can you change the Port to Dynamic and with Windows Authentication?
You can also, give permissions, if the BESMgmt2 seperately from SQL server. Once the Permissions have been setup, try it once.
Assign the BESMgmt2 for SystemAdmin permissions. then try to install it again.


http://btsc.webapps.blackberry.com/btsc/viewdocument.do?externalId=KB03633&sliceId=2&cmd=displayKC&docType=kc&noCount=true&ViewedDocsListHelper=com.kanisa.apps.common.BaseViewedDocsListHelperImpl
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

For those of you who are frightened by terms like SQL Server and think that C or C++ is an average or slightly above average grade on your homework, never fear. You've come to the right article. If you're like me, you look at the Experts on EE and f…
BlackBerry can provide (arguably) the best global email delivery solution. That is, until something goes wrong at which point it can be a nightmare to troubleshoot. The log files on a BES can only be decoded by an expert and some of the errors that …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question