Running BES 5.0.1 on Domino 8.5.1 (runs like a champ, with 225 users).
Last night we tried to move from local MSDE to SQL 2005 on a remote server (so we can get HA set up in the near future). Followed RIM KB12247 for the most part.
Setup allowed me to change the DB location & successfully test the connection, but when we reached the "application extensibility" section of setup, it bombed. Install log shows:
ConnectionItem::ConnectToDB: COM Error 0x80004005 - Unspecified error - Source: "Microsoft OLE DB Provider for SQL Server" - Description "Cannot open database "mdsis"
requested by the login. The login failed." - Command "ConnectionItem::ConnectToDB"
...at which point, setup simply stops. So here's the question. Everything I have seen regarding moving the config DB to another server talks about backing up & restoring (or copying & pasting) the BESMgmt MDF and LDF files, and the BMSStore MDF & LDF files. Even RIM support told me this. There are, however more database files on the BES than just those two (mdsis.mdf and .ldf included). Is it safe to assume that ALL of them should be recreated empty on the new SQL server (rather than just the two I mentioned), then populated via restore? Or is it really just those two - BESMgmt & BMSStore - that need to be moved?
Thoughts? Thanks so much!
Thankfully, we run BES on a VM - so we had a snapshot to fall back to.