[itcontractorltd]

Hi there,

Has anyone comes across a database error when installing BES 4.1 express on exchange 2003? When going through the process of installation and choosing Database Settings, I have opted for Local and the default options. It then asks if want to upgrade the database and if click Yes, it comes back with error to say Database Upgrade Failed, no others errors, but cannot continue with the install.

Any help appreciated.

[bertiebassett]

are you sure theres no dog end of a previous bes db hanging around...

[gziz]

it shouldnt ask you to upgrade the database if its a first time install since there isnt a blackberry database. try naming the database a diffrent name and it should ask you if you want to create the dataabse

[itcontractorltd]

That's what I thought. I have ren-named the existing databases, just in case. It does ask me if want to create the database now, and then when it completes that, comes back with error "DB upgrade failed. SQL function error"

any ideas about this? I have installed BES on several servers and never seen this error before.

[Domel]

Originally Posted by itcontractorltd

That's what I thought. I have ren-named the existing databases, just in case. It does ask me if want to create the database now, and then when it completes that, comes back with error "DB upgrade failed. SQL function error"

any ideas about this? I have installed BES on several servers and never seen this error before.

Have you checked the permissions for database?

[itcontractorltd]

well i thought about that, but the besadmin account has got the same access as the besadmin account on any other bes server i have installed...i know it shouldn't have but i have given it domain admin rights and still not made any difference. should it have any special SQL rights in AD?

[itcontractorltd]

any help with this pleaseeeeeeeeeeeee

[Domel]

Originally Posted by itcontractorltd

any help with this pleaseeeeeeeeeeeee

My BES is standing on MSDE so I don't have experience with BES&MSSQL.
Maybe sombody who uses MSSQL will answer.

[itcontractorltd]

should I try uninstall SQL server and then install it all again????

[GrandsireTriples]

The easy fix is not to use the default database name. e.g. add a 1 on the end. BESmgmt1.

[itcontractorltd]

I actually did try re-naming the database but still would not work.

I re-installed SQL and now it is working fine.

Thanks for all your responses

[haven.espinosas]

itcontractorltd, it sounds as if you had gotten it all resolved. how does one go about removing and reinstalling the SQL?