Link to home
Avatar of Bransby-IT
Bransby-IT

asked on

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

User generated image
When Selecting next I get the following error

User generated image
Advise would be great.
Avatar of Bransby-IT
Bransby-IT

ASKER

This is the first SQL Database on the new SQL Server.

I have checked that TCP is enabled and it is.
SOLUTION
Avatar of Rob Knight
Rob Knight
Flag of United Kingdom of Great Britain and Northern Ireland image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
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.
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.
Hi,

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

Regards,


RobMobility.
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.
Hi,

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

Regards,


RobMobility
I will chaeck now.
Just another thought - do you need to specify instance name and database name?

Regards,


RobMobility.
Still looking into this.
Still looking into this.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.