Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

BlackBerry Enterprise Server Express v5.0.4

Posted on 2013-01-08
14
Medium Priority
?
759 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
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 668 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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
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 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 664 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 668 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: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

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

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…
The latest Citrix Receiver has been released (May 2010) and is finally available for BlackBerry devices, version 1.0. Once installed, BB users can access Citrix applications from their device, on any* mobile network or WiFi connection. This is cu…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Suggested Courses
Course of the Month9 days, 7 hours left to enroll

877 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