BlackBerry Enterprise server express installation database error

Did you follow these instructions:
http://www.blackberry.com/btsc/viewContent.do?externalId=KB02276&sliceId=1#Task
Hope this helps.

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.
 

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?

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