Error applying SP4 to BackupExec 2012
Hello!
I get the following error when trying to apply SP4 to BackupExec 2012 installation on Windows Server 2008 R2. SQL database is on separate SQL server.
I manually stoped all BackupExec services before installation and checked on SQL server that there are no logins on BackupExec database.
After digging into the process of installing SP I found out where the problem is and also solution to the problem.
I looked into SQL upgrade script C:\Program Files\Symantec\Backup Exec\dbupgradebuildtobuild.sql. It shows that for the sake of SP install linked server BESERVER_DB is created which points to the SQL server with BEDB database. In this case it is the server itself. If linked server BESERVER_DB already exists (from previous installations), it is first deleted and then new one created. Linked server is created with default login (login using current security context). Previous liked server is deleted with command sp_dropserver 'BESERVER_DB'. This command deletes linked server and default login, but not any extra defined logins.
In our case existing linked server 'BESERVER_DB' had additional login tied to specific user. When upgrade procedure deleted linked server, extra login was not deleted and this then caused error. Correct command for linked server delete in the upgrade script would be sp_dropserver 'BESERVER_DB', 'droplogins'.
I simply deleted linked server BESERVER_DB and then SP4 install went OK.