Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 766
  • Last Modified:

BlackBerry Enterprise Server Express v5.0.4

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
Bransby-IT
Asked:
Bransby-IT
3 Solutions
 
Bransby-ITAuthor Commented:
This is the first SQL Database on the new SQL Server.

I have checked that TCP is enabled and it is.
0
 
Rob KnightConsultantCommented:
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
 
Bransby-ITAuthor Commented:
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
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Rob KnightConsultantCommented:
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
 
Rob KnightConsultantCommented:
Hi,

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

Regards,


RobMobility.
0
 
Bransby-ITAuthor Commented:
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
 
Rob KnightConsultantCommented:
Hi,

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

Regards,


RobMobility
0
 
Bransby-ITAuthor Commented:
I will chaeck now.
0
 
Rob KnightConsultantCommented:
Just another thought - do you need to specify instance name and database name?

Regards,


RobMobility.
0
 
Bransby-ITAuthor Commented:
Still looking into this.
0
 
Bransby-ITAuthor Commented:
Still looking into this.
0
 
Damian PippetDirector / ConsultantCommented:
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
 
bewaarseCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now