only search Wiseman.La

The World NEXT ends 

This is a true story, but of course, I won't reveal any names.

So, I have smaller client with a Blackberry Enterprise Server and 15 BB users.

The primary admin looks at the server and decides to do a summer clean up and stops all services and removes MS SQL Server (among a lot of other software). He then reboots the server and goes home. This apparently happened last night/early this morning.

His assistant calls me this morning wondering why their Blackberries aren't working any more. Now, if you know anything about BES, you'll know that it uses SQL server to store 99% of it's working data, so it kind of misses it when it's been removed.

I discover that SQL server is missing and ask for their RIM support info so I can huddle with them on the best way to fix this. Oops, their support expired .a year ago.

Also, I'm onsite with another client (100% busy) today, hundreds of miles away and access to their server is incredibly slow, like watching paint dry.

Under water.

So I figure I'll give a try, since they're desperate and I'm a nice idiot.

Luckily the brilliant person who installed their BES almost two years ago (guess who) left the install files for everything in a neat folder creatively called "Installed_Software".

I was able to use SQLRun01.MSI to install SQL Server, but of course, it didn't know about the existing BES databases, and being MSDE, there are no utilities to run to add them, except some arcane command line ones that probably won't do everything I need.

I was able to run through the BES set up, and make it create new, empty databases and then halt the config, stop MSSQL and replace the new DBs with the real ones. Then start & finish the BES config.

Surprisingly, this all worked, and they are back up and running.

And they are urgently buying a BES Support contract, because I said I wouldn't talk to them ever again unless they did.
SQL Install

Moral here? Don't remove software unless you know exactly what it is, why it's there, and are sure it's safe to remove.

Comments (3)
Craig Wiseman July 30th, 2008 11:44:59 AM

1) I did NOT expect that to work, but it did...!
Kevin 7/30/2008 2:01:55 PM


That's what that does.


2) I did NOT expect that to work, but it did...!
kevin 7/30/2008 2:03:12 PM

You have to hand it to divine providence smiling on the enterprising minded, like you.

3) I did NOT expect that to work, but it did...!
Craig 7/30/2008 2:12:14 PM


Although, one could argue that this is one approach to find out if software is safe to remove.

Discussion for this entry is now closed.