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

BlackBerry Enterprise server express installation database error

I have a sbs 2003 r2 server and i am trying to install the Blackberry enterprise server express, i get half way through the installation but when i get to the Database information section i get an error : An attempt to connect the database was unsuccessful. Refer to the installation log file for more information. The database is : Local, servername\sbsmonitoring, BB configuration database name is BESMgmt, port configuration is Dynamic, the data directory is: D:\program files\Microsoft SQL server\MSSQL$SBSMONITORING\DATA\", with Windows authentication.
0
mspencer100
Asked:
mspencer100
2 Solutions
 
ConchCrawlCommented:
Did you follow these instructions:
http://www.blackberry.com/btsc/viewContent.do?externalId=KB02276&sliceId=1#Task
Hope this helps.
0
 
Hypercat (Deb)Commented:
The problem you're encountering is most likely caused by the fact that the SBS server already has an instance of SQL Express installed, but it's a named instance (MSSQL$SBSMONITORING). The Blackberry server requires that a default instance of SQL be installed so that it can create its own database named "BESMgmt." It can't create that database and that's why you can't connect to it.  What you need to do is install a default instance of SQL Express 2005 and then the Blackberry install process will be able to create and connect to its own database.
You can download the install file for SQL Express 2005 here with instructions:
http://www.microsoft.com/downloads/details.aspx?FamilyID=3181842a-4090-4431-acdd-9a1c832e65a6&displaylang=en
During the install, be sure to select to install the "Default instance" instead of a named instance.
 
0
 
SysExpertCommented:
This is usually a consequence of the fact that SBS 2003 is already running SQL, and you need to install a new instance.

see

http://www.blackberry.com/btsc/microsites/search.do?cmd=displayKC&docType=kc&externalId=KB11232&sliceId=1&docTypeID=DT_SUPPORTISSUE_1_1&dialogID=356452169&stateId=0%200%20356442476

I hope this helps !
0
[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

 
mspencer100Author Commented:
Okay i have SBS2003 R2 so i went with the SQL Server Express edition. The current BB installation is at "Database Information" i have it set to local, Microsoft SQL Server name:  "ServerName\SBSMonitoring"
Blackberry configuration database name:  "BESMgmt" Port Configuration is "Dynamic" the data directory c:\program files\Microsoft SQL Server\MSSQL$SBSmonitoring" and the backup dir are the same. it is set up for Windows authentication.

Here are my questions.
Server name, i entered <servername>\BlackBerry
DB Name: Not sure what it should be?
do i keep the default DIR's or point to a new locations(s)?
And i have Windows authentication.

I did not do the name instance in MSDE should i have?

0
 
ConchCrawlCommented:
You are trying to connect through named pipes not a database, you are using the incorrect pipe name.

For a default instance, use the following pipe in the Server Network Utility:
\\.\pipe\sql\query
For a named instance, use:
\\.\pipe\MSSQL$instancename\sql\query
Hope this helps

0
 
Hypercat (Deb)Commented:
If you correctly installed the SQL Express default instance, then you would use just "Servername" for the SQL server and then BESMgmt for the Blackberry database name.
You can keep the default directories unless you have space issues on the C: drive on your server. The default installation of SBS puts everything on the C: drive. If that matches your configuration, if your C: drive is pretty full and if you have another volume on your server, you might want to put the BB software there. Blackberry doesn't care - it's up to you.
Using Windows authentication is fine. This will mean that the user that is logged on when you install the Blackberry software will have full admin rights to the Blackberry database.
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

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