Update: I completed the Upgrade to BES 4.1.6 MR1 without a hitch (yay!)
Now, after I first check to make sure that there is no mapping to the old connection service, then I go into "Delete MDS Connection Service" I imediately get a popup stating "There are no qualifying connection services entries to delete. The must not be mapped as servicing any BES and must be uninstalled (no service present) on the server."
It's no longer mapped to anything and the MDS Connection service is pointing to the new and working MDS connection service.
Any thoughts before I go the manual edit of the database route? I know it's not really hurting anything, but I'm anal and I just don't like seeing the old server referenced like that.
And if I DO use the query listed above, for ServerName do I list it EXACTLY as it's listed in the BES manager? (It's listed as OLDSERVERNAME_MDS-CS_1)
Thanks again for all the help guys!