BlackBerry® Professional Software and BlackBerry® Enterprise Server Express

[ajwade01]

Hi,

We are running BB Professional 4.14, using SQL Server Express as our DB.

Old Server:

Windows 2003 Standard SP2

Computer name: WSUS

BES name: WSUS

SQL Express 2005 DB: BESMgmt

New Server:

Windows 2003 R2 Standard

Computer name: vm-server01

BES name:  WSUS

SQL Express 2005 DB: BESMgmt

I followed KB10278 to perform a knife-edge cutover. However, mistakenly did not Update the BlackBerry Configuration Database schema, on the new server, as directed in Task 2, Step 4, of KB03112. Instead, I just restored my existing BESMgmt database to the new server. After I realized me error, I followed these instructions to try and fix it:

Extract the service pack for the BlackBerry Enterprise Server software version that you are using to a folder location.
Copy the Database folder from the extracted folder location to the remote Microsoft SQL Server.
Open the BESMgmt.cfg file in a text editing application (e.g. Microsoft Notepad).
Type cmd=Migrate.
Make sure the Microsoft SQL Server and BlackBerry Configuration Database names are correct.
Save and close the BESMgmt.cfg file.
Open a command prompt and navigate to the database folder.
From the command prompt, type createdb besmgmt.cfg.
Confirm the account with which you are logged into the Microsoft SQL Server has access to the BlackBerry Configuration Database.
Start the BlackBerry Dispatcher service.

However, the createdb besmgmt.cfg command errors out. Here are the last four lines of the log file:

[30000] (11/07 18:40:45.008):{0xA88} Schema is being upgraded
[20000] (11/07 18:41:01.461):{0xA88} SQL Error Message from CBESDBInstaller::Connect: SQLSTATE: 08001 Native error: 17 Message: [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.
[30000] (11/07 18:41:01.461):{0xA88} SQL Informational Message from CBESDBInstaller::Connect:  [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).
[20000] (11/07 18:41:28.727):{0xA88} Terminating because of connection failure.  Connect string: DRIVER={SQL Server};SERVER=(local);UID=;PWD*
====== END OF LOG ======

I am having trouble figuring out what the above error means?

Any help would be greatly appreciated.

[CerealBypass]

"SQL Server does not exist or access denied" seems to indicate that there is a permissions issue. Are you running createdb using the service account? If so, make sure it's a local admin on the new box.

Just to make things a little easier, I would try this:

- Make sure you have a backup of your old DB (a .bak backup)

- On the new server (and new SQL) drop the besmgmt database entirely

- Using the service account (BPSAdmin or whatever you called it) run createdb with the CMD=Install and all the defaults

- Restore the .bak file on top of the new blank besmgmt DB

- Install BPS on the new server, pointing to the database and making sure to use the same instance name.

Sounds like you had most of it right. Nuking the BESMGMT database on the new server might help you keep things a little cleaner.

[ajwade01]

I'm sorry but I forgot to mention that I have already installed BPS. I then realized that I should have ran the createdb.exe BESMgmt.cfg command.

Yes, I am runnig createdb using the BESAdmin account. BPS is installed on a BDC and BESAdmin is a member of the Domain Builtin Adminstrators Group.

I do have my original .bak backup.

Should I uninstall BPS, then follow your instructions and reinstall BPS.

Thanks for the help!

[CerealBypass · Accepted solution]

Yes uninstalling BPS from the new machine before you do anything else would be optimal. This will help you avoid issue with the MDS-CS.

- Grab a backup of the original DB

- Make sure the service account is a local admin on the new box

- Uninstall BPS

- Run createdb with all the default config options (thus, creating a blank database with the appropriate schema)

- Restore your database to the blank one

- Install BPS making sure to use the same instance name

[ajwade01]

Thanks. Will do.

A couple of things:

In my case the old BPS server's computer name was WSUS and the BPS name was WSUS. My new server's computer name is VM-Server01. According to the the knife cut-over instructions. I want to name the new BPS WSUS then. Correct?

[ajwade01]

I get this error when trying to Restore from my backup DB:

TITLE: Microsoft SQL Server Management Studio Express
------------------------------

Restore failed for Server 'VM-SERVER01\SQLEXPRESS'.  (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&Evtsrc=Microsoft.S...

------------------------------
ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing 'BESMgmt' database. (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

[ajwade01]

I check the option to "Override existing database" before restoring and the restore worked. I then was able to successfully install BPS again.

Thanks for all of you help. I really appreciate it.

[knottyrope]

You ran into aqll the same things I did during a MSDE to SQL conversion and the doing a knife edge cutover.

Knot fun but glad you are up and running