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.
mspencer100Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SBS

From novice to tech pro — start learning today.