Solved

Blackberry Enterprise Server Remote DB Connection

Posted on 2010-08-25
2
644 Views
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!
BES-Express.jpg
0
Comment
Question by:ICG
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 8

Expert Comment

by:bpinning
ID: 33527208
Hi,

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.
0
 
LVL 1

Accepted Solution

by:
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.
0

Featured Post

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

Question has a verified solution.

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

Utilizing an array to gracefully append to a list of EmailAddresses
Marketers need statistics and metrics like everybody else needs oxygen. In this article we explain how to enable marketing campaign statistics for Microsoft Exchange mail.
In this Micro Video tutorial you will learn the basics about Database Availability Groups and How to configure one using a live Exchange Server Environment. The video tutorial explains the basics of the Exchange server Database Availability grou…
This video discusses moving either the default database or any database to a new volume.

739 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