Blackberry Enterprise Server Remote DB Connection

Posted on 2010-08-25
Medium Priority
Last Modified: 2012-08-14
I am attempting to install BES Express on a server running MSExchange 2010.  I have another server running SQL Server 2008 R2 Enterprise.  I selected to use an existing SQL server instead of installing a SQL Server Express edition on my Exchange server.

BES install has reached a point where everything is installed correctly until I get to the db connection screen.  Attached is a screenshot showing that I have selected a remote SQL instance, used the default config db name, used the static port 1433 as verified in SQL Server Management for TCP/IP and used Windows authentication (which is the authentication for the SQL server).

Because this is a "remote" SQL server, I am not sure what to use for the server name.  I have tried the internal IP, internal IP\SQL instance (as shown in attached image), the SQL host name, host name\instance name, internal IP\hostname, hostname\internal IP....

At this point I am at a lost.  I followed the directions RIM provided on the BES Express website.  At this point I am not sure if it is a permissions error or the syntax that I am using to connect to the SQL server.  RIM provides no info for remote SQL server connections as they suggest using SQL Server Express (boooo!).  Help on EE would be greatly appreciated!
Question by:ICG

Expert Comment

ID: 33527208

Are you using MSDE? by default, MSDE loads with no network connections. If you look in \program files\microsoft sql server\80\tools\binn there is a utility called svrnetcn.exe which will allow you to add a network connection. You'll have to restart SQL for it to kick in.

Accepted Solution

ICG earned 0 total points
ID: 33528381
Saw this on multiple forums but had no solution posted.  Would be helpful to know that once port 1433 was opened on windows firewall on SQL server the installation process continued.

Featured Post

Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

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

Exchange database can often fail to mount thereby halting the work of all users connected to it. Finding out why database isn’t mounting is crucial and getting the server back online. Stellar Phoenix Mailbox Exchange Recovery is a champion product t…
Here is a method which can be used to help resolve a "Content Index Failed" error on a Microsoft Exchange Server.
To show how to generate a certificate request in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.:  First we need to log into the Exchange Admin Center. Navigate to the Servers >> Certificates…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

600 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