We tried to move SQL off locally and point BES 4.0 to the new remote SQL box last night with no luck. The new remote sql server is Windows 2003 and SQL 8.0. sp3. The BES has Windows 2000. We followed the steps from KB 03112, but when changing the DB server name and hitting next it came back with "DB upgrade failed. Error executing a SQL statement".

Now, we found and article on that statement but it was for 4.1 and made no sense.

Any ideas

Try this, delete the database you moved to the SQL server. Then in the BES server configuration screen change your SQL server name....this will create a blank (empty) BESMgmt database on the SQL box. THEN restore your .bak (or however you're moving the current SQL database) file to that NEWLY created BESMgmt. This will populate the newly created BESMgmt on the SQL server with all the appropriate data from the old SQL box/install.

Tried it again last night. no luck. Had to escalate with RIM experts and waiting for call.

We tried pointing the BES to another sql box with the 2000 windows server. No luck..

What a strange error.. Anyone ever ran into this..

Did you allow the BES configuration to create a blank BESMgmt database on your new SQL box, then restore your current BESMgmt into the newly created database?

I just ask because we recently did a knife-edge cutover to a new server and SQL server and got the same message. We already had restored the current BESMgmt to the new SQL server then tried pointing the BES server config page to the new SQL server and got the same error. Only by removing the BESMgmt from the new SQL box and allowing the BES server config screen create a blank BESMgmt then restoring the data into the DB did things start working......

Awesome, That worked.

So tonight we are going to move a copy of the active DB into the blank DB and cross our fingers.

The new bes has a new computer name. During the install of bes it asked for the server name and I put the old bes name in. That is our only other concern.. heard that would work without having to reactivate,

You MUST keep the BES server name the same....the computer name can be different.