• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 654
  • Last Modified:

Blackberry Enterprise Server and SQL Server 2005

I am in the process of setting up the Blackberry Enterprise Server software on a Server 2003 box.  I am also running WSUS on this server which is using a SQL Server Express database that is on the local machine.  We do have a dedicated server running SQL Server 2005 for our MS Dynamics CRM software.  

Would you recommend installing BES and allowing it to create a SQL Express database on the local machine or should I have the BES database reside on the dedicated box running the full version of SQL Server 2005?

If you recommend running the database on the full version of SQL Server be prepared to answer some more questions ;)  

As of right now, we only have two Blackberry users.  This will probably increase over time but probably will never exceed 20 users.  
0
csimmons1324
Asked:
csimmons1324
  • 5
  • 3
  • 3
2 Solutions
 
SysExpertCommented:
Tough call.
If you use external SQL, then whenever that machine goes down, you lose BES.

If local, you may need some extra help with the install, since the instance name probably will not be standard.


I would try to keep it local for a small amount of users, and check the RIM support site on how to do MSDE install for an existing express server.

Contact RIM if you have issues.

I hope this helps !
0
 
csimmons1324Author Commented:
I am leaning toward using the full version of SQL Server 2005 to host the database for BES for a number of reasons.  First, that SQL box should be much more reliable than the box that is running the BES software.  Therefore, if the BES server ever goes down then I should just have to reinstall the software and point it to the SQL database, correct?  Also, I have a SQL Agent installed on the SQL Server for ARCserve to backup my SQL databases.  This would make backing up the BES database much easier.

The BES isn't mission critical.  If it ever goes down then I have a hand full of users who can't access email on their Blackberries....no biggie.  

Does anyone know where I can find detailed instructions on how to setup the database to run on a separate SQL server?
0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
SysExpertCommented:
It should be in the install guide for BES on the RIM support site.


I hope this helps !
0
 
EddyJacksonCommented:
RIM only has an article on moving the BlackBerry Configuration Database - http://www.blackberry.com/btsc/search.do?cmd=displayKC&docType=kc&externalId=KB03112&sliceId=1&docTypeID=DT_SUPPORTISSUE_1_1&dialogID=38216779&stateId=1 0 38228003.

I believe the setup walks you through the database setup.
0
 
csimmons1324Author Commented:
In that document, I am having trouble with the following:

"   1. Click Start > Microsoft SQL Server 2005 > Configuration Tools > Microsoft Server Configuration Manager > Microsoft Server 2005 Network Configuration.
   2. Select the Microsoft SQL Server instance that will be used for the BlackBerry Configuration Database.
   3. If necessary, turn on the TCP/IP and Named Pipes protocols.
   4. If a protocol is turned on in the previous step, restart the Microsoft SQL Serverservices. "

I am not sure where or how to select an instance?  I have gone into the SQL Server Configuration Manger and selected SQL Server 2005 Network Configuration but there is nothing I can do at this screen.
0
 
SysExpertCommented:
Are you an admin for the SQL 2005 server ?

0
 
csimmons1324Author Commented:
Yes, I am logging into the server as an admin.
0
 
csimmons1324Author Commented:
Can I go ahead and create / install the BES database while logging into the our SQL Server under the Administrator account?  Will it matter if the database resides on the same instance of our CRM database?
0
 
csimmons1324Author Commented:
Can anyone answer if it is ok to reside on the same instance as our CRM database?
0
 
EddyJacksonCommented:
I assume you mean CRM database SERVER..?  If the load of the CRM datbase isn't too taxing of the server it resides on, then yes.  That being said, most BES installations I've come across have the database running local to the BES.
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

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