Welcome!

Welcome to the official BlackBerry Support Community Forums.

This is your resource to discuss support topics with your peers, and learn from each other.

Reply
New Contributor
Alan12345
Posts: 5
Registered: ‎11-05-2012
My Device: Curve
Accepted Solution

BlackBerry Express Install SQL connectivity problems

I am doing a clean install of Blackberry Express 5.0.4 on a reformatted empty Windows 2003 server SP2.

 

The first attempt failed with the local database button greyed out, only remote was selectable.

 

Eventually read in known issues, that you could install SQL server express before doing the install as a workaround for a different problem.

 

Installed SQL express 2008, local button available, but then could not find a connection to the database.

 

Doing a reformat back to base 2003 SP2 at the moment, going to try with SQL 2005 express next, as in compatibility matrix SQL 2008 has ”LS” against it.

 

1)      Anyone know if there is a document describing how and what you need to do to after installing SQL express before installing Blackberry software.

 

2)      The first problem was “local” database option greyed out/not available any advice on what the basic problem in this area is?.

 

 

Thanks

Please use plain text.
Guru III
knottyrope
Posts: 30,622
Registered: ‎06-25-2008
My Device:

I'm rockin the BlackBerry Passport, Z30, Z10, Q10, BlackBerry Mini Stereo Speaker, 64 gig PlayBook, BlackBerry Wireless Headset HS-700

My Carrier: I am on AT&T. Please edit your Personal Profile with your DEVICE TYPE, DEVICE OS and Carrier

Re: BlackBerry Express Install SQL connectivity problems

install SQL Express with the BESAdmin account locally and not with TS or RDP

 




Click here to Backup the data on your BlackBerry Device! It's important, and FREE!


Click "Accept as Solution" if your problem is solved. To give thanks, click thumbs up
Click to search the Knowledge Base at BTSC and click to Read The Fabulous Manuals

BESAdmin's, please make a signature with your BES environment info.


SIM Free BlackBerry Unlocking FAQ
Follow me on Twitter @knottyrope


Want to thank me? Buy my KnottyRope App here


BES 12 and BES 5.0.4 with Exchange 2010 and SQL 2012 Hyper V


Please use plain text.
New Contributor
Alan12345
Posts: 5
Registered: ‎11-05-2012
My Device: Curve

Re: BlackBerry Express Install SQL connectivity problems

Hi,

 

Just to let anyone know that in my case it was necessary to install SQL express before installing the Blackberry Express Software. The 5.0.4 package failed to install and link to SQL, but it could link to an already installed SQL software.

Please use plain text.
Regular Contributor
jeprue
Posts: 54
Registered: ‎11-23-2011
My Device: Z10

Re: BlackBerry Express Install SQL connectivity problems

I'm running into the same problem.  Is the SQL Server express install included in the BES Express installer package or do I need to download it from Microsoft?  If it is included, how do I run just the SQL Server install?  I've been fighting with this all morning and I'm beyond frustrated.

 

Thanks!

Please use plain text.
Guru III
knottyrope
Posts: 30,622
Registered: ‎06-25-2008
My Device:

I'm rockin the BlackBerry Passport, Z30, Z10, Q10, BlackBerry Mini Stereo Speaker, 64 gig PlayBook, BlackBerry Wireless Headset HS-700

My Carrier: I am on AT&T. Please edit your Personal Profile with your DEVICE TYPE, DEVICE OS and Carrier

Re: BlackBerry Express Install SQL connectivity problems

SQL is part of BES installer, but if you have an existing version of SQL then you need to know the SA account (or apply the proper permissions to SQL) to upgrade it or to install the database.

 




Click here to Backup the data on your BlackBerry Device! It's important, and FREE!


Click "Accept as Solution" if your problem is solved. To give thanks, click thumbs up
Click to search the Knowledge Base at BTSC and click to Read The Fabulous Manuals

BESAdmin's, please make a signature with your BES environment info.


SIM Free BlackBerry Unlocking FAQ
Follow me on Twitter @knottyrope


Want to thank me? Buy my KnottyRope App here


BES 12 and BES 5.0.4 with Exchange 2010 and SQL 2012 Hyper V


Please use plain text.
Contributor
harpert
Posts: 27
Registered: ‎01-22-2009
My Device: Not Specified

How To avoid SQL connectivity problems when re-installing BES Express

Hi,

 

It has taken some day and nights, but..... I have found what caused my problems:

 

1: INSTALL ONLY USING THE BESADMIN account

my problem was that I used the most logical account, the ADMIN account

RIM in their eternal wisdom, decided that you need to make a new (exchange) user, called BESAdmin and ONLY use that account to setup BESExpres.

 

2: FOLLOW THE STEPS of the instruction video
you need to follow these steps to the letter.

InStead of making a proper installation procedure for the most common installations,
RIM made is very complicated to perform the simplest tasks.

YES it does give many possibilities for big corporate Admins to change nearly everything,

But sure is not contributing to the small / medium organisations with 2 - 10 phones that install BESExpress on the same machine as Exchange 2007 is running.

 

3: If you have made the mistake of installing using the Admin account and not BESAdmin, you will get stuck with SQL database connection.
The Solution..... Don't use the default name suggested by the installation procedure, but use a different name for the database
The old database will remain, even when uninstalling SQL 2008 and ofcourse has all the rights linked to your Admin account.
just create a new one.

 

4: When the installation procedure is done. the BESExpress software runs very smooth.

It's just a matter of following the manual (which nobody ever does) to the letter.

All problems arise from not doeing EXACTLY what RIM puts in the instructions
There is no  "quick and dirty" when installing BESExpress on the same machine as Exchange 2007 / 2010

 

It took me nearly 2 weeks between other jobs to get BESExpress working for 3 !!! users.

It turned out that if I just have followed instructions... all would have worked within 2 hours.

 

Personally I believe that RIM should put a VERY large warning in the SETUP procedure that says....
FOLLOW THE INSTRUCTIONS TO THE LETTER

and

DON"T USE YOUR STANDARD ADMIN ACCOUNT FOR INSTALLATION

 

it's is not common that the ADMIN account can't be used for instalation.

 

Harpert

If installing BESEXPRESS on a DUTCH WINDOWS version..... set your country settings to UK or US!!!

otherwise SETUP will never start.

 

 

 

Please use plain text.
Guru III
knottyrope
Posts: 30,622
Registered: ‎06-25-2008
My Device:

I'm rockin the BlackBerry Passport, Z30, Z10, Q10, BlackBerry Mini Stereo Speaker, 64 gig PlayBook, BlackBerry Wireless Headset HS-700

My Carrier: I am on AT&T. Please edit your Personal Profile with your DEVICE TYPE, DEVICE OS and Carrier

Re: How To avoid SQL connectivity problems when re-installing BES Express


harpert wrote:

Hi,

 

It has taken some day and nights, but..... I have found what caused my problems:

 

1: INSTALL ONLY USING THE BESADMIN account

my problem was that I used the most logical account, the ADMIN account

RIM in their eternal wisdom, decided that you need to make a new (exchange) user, called BESAdmin and ONLY use that account to setup BESExpres.

 

2: FOLLOW THE STEPS of the instruction video
you need to follow these steps to the letter.

InStead of making a proper installation procedure for the most common installations,
RIM made is very complicated to perform the simplest tasks.

YES it does give many possibilities for big corporate Admins to change nearly everything,

But sure is not contributing to the small / medium organisations with 2 - 10 phones that install BESExpress on the same machine as Exchange 2007 is running.

 

3: If you have made the mistake of installing using the Admin account and not BESAdmin, you will get stuck with SQL database connection.
The Solution..... Don't use the default name suggested by the installation procedure, but use a different name for the database
The old database will remain, even when uninstalling SQL 2008 and ofcourse has all the rights linked to your Admin account.
just create a new one.

 

4: When the installation procedure is done. the BESExpress software runs very smooth.

It's just a matter of following the manual (which nobody ever does) to the letter.

All problems arise from not doeing EXACTLY what RIM puts in the instructions
There is no  "quick and dirty" when installing BESExpress on the same machine as Exchange 2007 / 2010

 

It took me nearly 2 weeks between other jobs to get BESExpress working for 3 !!! users.

It turned out that if I just have followed instructions... all would have worked within 2 hours.

 

Personally I believe that RIM should put a VERY large warning in the SETUP procedure that says....
FOLLOW THE INSTRUCTIONS TO THE LETTER

and

DON"T USE YOUR STANDARD ADMIN ACCOUNT FOR INSTALLATION

 

it's is not common that the ADMIN account can't be used for instalation.

 

Harpert

If installing BESEXPRESS on a DUTCH WINDOWS version..... set your country settings to UK or US!!!

otherwise SETUP will never start.

 

 

 


an experienced exchange admin would know that when dealing with the sendas permissions you can not use a domain admin account. I have tried to tell you this a few times. I did this too 6 years ago and could not believe the tech fixed it in 5 minutes. Since then I have helped out 1000s of people. If you wont follow he directions, not much can be done and a hard lesson learned. Glad to see you have it running now. Even if RIM put in bold red letters some one would think "yeah right i can use my admin account" and do the same as you.

 




Click here to Backup the data on your BlackBerry Device! It's important, and FREE!


Click "Accept as Solution" if your problem is solved. To give thanks, click thumbs up
Click to search the Knowledge Base at BTSC and click to Read The Fabulous Manuals

BESAdmin's, please make a signature with your BES environment info.


SIM Free BlackBerry Unlocking FAQ
Follow me on Twitter @knottyrope


Want to thank me? Buy my KnottyRope App here


BES 12 and BES 5.0.4 with Exchange 2010 and SQL 2012 Hyper V


Please use plain text.
New Contributor
Alan12345
Posts: 5
Registered: ‎11-05-2012
My Device: Curve

Re: BlackBerry Express Install SQL connectivity problems

Hi,

 

SQL Express is inclded in the installer package, but I could not get it to work properly. I downloaded from Microsoft and installed seperately, before starting the BES package, then all worked OK. I downloaded SQL 2005 version, rather than the 2008 version included in the package.

Please use plain text.
Guru III
knottyrope
Posts: 30,622
Registered: ‎06-25-2008
My Device:

I'm rockin the BlackBerry Passport, Z30, Z10, Q10, BlackBerry Mini Stereo Speaker, 64 gig PlayBook, BlackBerry Wireless Headset HS-700

My Carrier: I am on AT&T. Please edit your Personal Profile with your DEVICE TYPE, DEVICE OS and Carrier

Re: BlackBerry Express Install SQL connectivity problems

glad to see your doing ok Alan.

 




Click here to Backup the data on your BlackBerry Device! It's important, and FREE!


Click "Accept as Solution" if your problem is solved. To give thanks, click thumbs up
Click to search the Knowledge Base at BTSC and click to Read The Fabulous Manuals

BESAdmin's, please make a signature with your BES environment info.


SIM Free BlackBerry Unlocking FAQ
Follow me on Twitter @knottyrope


Want to thank me? Buy my KnottyRope App here


BES 12 and BES 5.0.4 with Exchange 2010 and SQL 2012 Hyper V


Please use plain text.
Regular Contributor
jeprue
Posts: 54
Registered: ‎11-23-2011
My Device: Z10

Re: BlackBerry Express Install SQL connectivity problems

I am using the BESadmin account so that's not my problem.  I'm not installing on the same machine as our Exchange 2010.  I guess I could try downloading SQL 2005 Express.  I was hoping I could just use the version that came with BES Express but after wasting my whole Friday with nothing to show for it, I have to do something.   Thanks for the suggestions.

Please use plain text.