Solved

BlackBerry Enterprise Server Express v5.0.4

Posted on 2013-01-08
14
742 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 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
Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

 
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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

For many people, the BlackBerry is an indispensable tool during their working day. The ability to have your emails delivered swiftly and securely to your hand can improve your personal efficiency immensely. So, how many people do you see with their …
Have you ever wondered if there is a way to get a message delivery receipt without interrogating the BlackBerry log files or using the Resource Kit tools? It is possible using this tip: When troubleshooting whether a BlackBerry is receiving email…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

813 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now