Backup Exec 2014 SP1 Environment Check issue

[LANTech]

Good morning,

I am planning on upgrading from Backup Exec 2012 SP4 to Backup Exec 2014 SP1.

After I ran the Environment Check, I got one 'Failed'.
The Microsoft SQL Server upgrade may fail because the account security identifiers (SIDs) of the SQL service group accounts created during the Backup Exec SQL instance installation cannot be mapped to the SIDs currently assigned to the SQL service group accounts

The link for more information points to http://entsupport.symantec.com/umi/V-225-303, but there does not appear to be an article there.

Can someone please point me to the correct article?

Thank you.

[Sym-cr · Accepted solution]

Hi LANTech,

Although the article provided below is not for an upgrade from BE 2014 to SP1. However, Solution C in this article might help you.

Upgrade to Backup Exec 2014 fails with error -2067922409 when SQL Server 2008 R2 Express with SP2 fails to install

http://www.symantec.com/docs/TECH216807

Thanks!!

[lmosla]

Hi LANTech,

Also refer to  http://www.symantec.com/docs/TECH64580

[CraigV]

...since this hasn't actually happened yet, and this occurs during the environment check, run the upgrade and see what happens. It might just be a warning, while the application will go through.

Otherwise try the following:

1. Stop any AV installed on the media server and run the Environment Check again.

2. Make sure that your media server is fully patched with any latest patches and BE service pack before doing the upgrade.

3. Stop the BE services and grab copies of the Data/Catalogs folders...this allows for a manual recovery if anything goes wrong during the upgrade (actually recommended with/without warnings of failures before upgrading).

Thanks!

[LANTech]

Thank you all for your contributions. I will have a look at those support articles and will try CraigV's steps.

[LANTech]

OK, may have found the issue/an issue. I ran FIX_SQLSID_For_BEUPG.ps1 from TECH216807.

Got the error:

Some or all identity references could not be translated.
Unable to retrieve the SQL Group account SID. Verify the SQL group SQLServer2005MSSQLUser$CURRENT$BKUPEXEC exists. Script
 terminating.

"CURRENT" is our current Backup Exec Server. The group that exists is SQLServer2005MSSQLUser$ORIGINAL$BKUPEXEC. "ORIGINAL" was our original Baclup Exec Server which no onger exists.

Can I just create the group SQLServer2005MSSQLUser$CURRENT$BKUPEXEC and put the same user account that is in SQLServer2005MSSQLUser$ORIGINAL$BKUPEXEC? Then maybe run the script again to update the SID?

Thanks.

[VJware · Accepted solution]

Yes, you can create the group and would recommend to follow Solution B from the above mentioned KB.

[LANTech]

New group created, script run, Pre-install check is clean now. Thank you all for your help.