[cdbesadmin]

Hi everyone,

Desperately trying to upgrade our BES server, but always being prompted with the error message:

"The setup application determined that you are not running a supported version of Microsoft SQL Server or Microsoft SQL Server Express Edition. Before you continue the current installation process, you must upgrade the database server to a supported version. For more information about system requirements for Blackberry Enterprise Server databases, see the Blackberry Enterprise Server Upgrade Guide."

I can't quite follow it, as we use MS SQL 2008 SP2. BES database compatibility level is also set to 2008.

Any ideas?

[knottyrope]

did you have MSDE installed on the BES server?

BlackBerry - BlackBerry Enterprise Server Compatibility - US

[cdbesadmin]

The infrastructure is here longer than I am. The BES database (2k8 64-bit) and BES administration (2k8 64-bit) servers are physically separated. From what I know the current database server was installed with SQL 2008 before it was upgraded to SQL 2008 SP2. Also I have been told that the Blackberry database apparently resided on the BES server itself, before it was moved to the dedicated database server. I am unsure of what DB version was running on the BES, but I assume it was SQL 2005.

[knottyrope]

if you are unable to determine if SQL or MSDE is installed on a server maybe you should have some one more experienced with IT look at it.



Find your Installed SQL Server Versions and Instances « Learning SQL Server

[cdbesadmin]

it's not that i don't know the difference between SQL and MSDE, I simply said I don't know if MSDE was installed before I joined the company. At the moment there is only SQL 2008 SP2 installed on the server the BES database is running on.

[knottyrope]

log onto the BES server, go to add remove programs and see if SQL is installed and report back please

[knottyrope]

You can see what BES is useing for SQL with this
Change BES 5.0 Configuration Database

If BES has a version of SQL installed on it and you are using a different SQL server for your database. Uninstall SQL from BES.

[cdbesadmin]

thanks knottyrope. Following your URL I can see that BES is using the correct DB on the dedicated DB server. On the BES server itself there is no MS SQL Server installed, but the SQL native clients installed seem to be out of date (2005.90.3042.00 and 2007.100.2531.00). do you think that could have an impact? I would need to request a maintenance window in order to update them.

[freakinvibe]

On your dedicated SQL server, check if all the components are really upgraded to SQL 2008, see:

Upgrade to BESX 5.0.3 - Not detecting SQL Upgrade - BlackBerry Support Community Forums

On the BES server, make sure that you have the "Microsoft SQL Server 2008 Native Client" installed.

[cdbesadmin]

SQL software on servers....

BES server:
Microsoft SQL Server 2008 Native Client (10.1.2531.0)
Microsoft SQL Server Native Client (9.00.3042.00)

DB server:
Microsoft SQL Server 2008 (64-bit)
Microsoft SQL Server 2008 Browser (10.2.4000.0)
Microsoft SQL Server 2008 Native Client (10.2.4064.0)
Microsoft SQL Server 2008 Setup Support Files (10.2.4064.0)
Microsoft SQL Server VSS Writer (10.2.4000.0)
Microsoft SQL Server 2005 Backward compatibility (8.05.2309)


May the version of 2008 Native Client on the BES be the problem?

[freakinvibe]

I have the same versions and the upgrade to SP3 worked for me. The native clients are installed by the BES setup, they are in the "Tools" subfolder:

sqlncli_x64.msi
sqlncli10_x64.msi

You can try to re-install from there, but I don't think that will help.

You should probably check the setup log to find a more detailed error.

[cdbesadmin]

unfortunately still haven't got any further. any other ideas? create a new db and import settings from existing?

[freakinvibe]

You should probably check the setup log to find a more detailed error.

[cdbesadmin]

...
[30000] (08/21 11:23:47.695):{0x2340} <5>Aug 21 11:23:47 BESserver  {0x1A90} 1011: (#30000) [ENV] [DB] Connection String = Server=BESdbserver;Database=BESMgmt;Network=dbmssocn;Trusted_Connection=Yes
[30000] (08/21 11:23:47.695):{0x2340} <5>Aug 21 11:23:47 BESserver  {0x1A90} 1012: (#30000) [ENV] [DB] DBMS Name = Microsoft SQL Server;  DBMS Version = 10.00.4064;  Provider Name = sqloledb.dll;  Provider Friendly Name = Microsoft OLE DB Provider for SQL Server;  OLE DB Version = 02.70;  Provider Version = 06.00.6002
[30000] (08/21 11:23:47.695):{0x2340} <5>Aug 21 11:23:47 BESserver  {0x1A90} 1013: (#35019) [ENV] [DB] Database Schema Version:  5.0.2 <5.0.2010.05.19>
[30000] (08/21 11:23:47.695):{0x2340} <5>Aug 21 11:23:47 BESserver  {0x1A90} 1014: (#30000) VerifyVersions: server: BESserver - version: 5.0.2.17
[30000] (08/21 11:23:47.695):{0x2340} <3>Aug 21 11:23:47 BESserver  {0x1A90} 1015: (#10000) [PIPTOOL]: 1. The setup application determined that you are not running a supported version of Microsoft SQL Server or Microsoft SQL Server Express Edition. Before you continue the current installation process, you must upgrade the database server to a supported version. For more information about system requirements for BlackBerry Enterprise Server databases, see the BlackBerry Enterprise Server Upgrade Guide.
...

doesn't really make sense to me. it determines a supported version, but it's telling me it's not supported.

[freakinvibe]

The only difference I see in my setup file is that the Provider version is

06.01.7600

So I guess you should try to upgrade the Microsoft SQL Server Native Client on the BES manually to match the version on the SQL server.

[cdbesadmin]

unfortunately, not something we can do during production.

in the meantime, we've created a copy of our BES database and performed a manual test db upgrade as described in the upgrade manual (via cmd). it worked like a charm. not sure why the upgrade isn't working using the upgrade app.

[cdbesadmin]

for anyone interested i was finally able to install BES 5.0.4

I could not identify the problem to 100%, but assume it has to do with the DB server storing it's databases on mapped LUN drives on our storage, instead of local DB server disks.

I've back'ed up the BESMgmt DB and restored it on a different DB server with no LUNs connected, run the BES upgrade installer to upgrade the DB on the new server. I then made a backup of the upgraded DB, restored it on the original DB server and ran the upgrade installer again to point the DB server address to the original DB server.

As mentioned, the LUN thing is just an assumption, but the workaround seemed to do the trick.