Upgrading server components from UI fails

brosato

I get errors and have to manually install on 30+ servers. It never has worked for me.


sv0220sqlmon1\dba: Server Component Installation - Failed
=========================================================

Checking Permissions - Successful

---

Click 'Retry' to reinstall the server components. If this problem persists, it may be necessary to uninstall the server components manually, and then reinstall by running SQBServerSetup.exe on the server. See red-gate.com/sqbmanualinstall


Copy SQBServerSetup.exe to server - Successful

---

Click 'Retry' to reinstall the server components. If this problem persists, it may be necessary to uninstall the server components manually, and then reinstall by running SQBServerSetup.exe on the server. See red-gate.com/sqbmanualinstall


Run setup on server - Successful

---

Click 'Retry' to reinstall the server components. If this problem persists, it may be necessary to uninstall the server components manually, and then reinstall by running SQBServerSetup.exe on the server. See red-gate.com/sqbmanualinstall


Start SQL Backup Agent service - Successful

---

Click 'Retry' to reinstall the server components. If this problem persists, it may be necessary to uninstall the server components manually, and then reinstall by running SQBServerSetup.exe on the server. See red-gate.com/sqbmanualinstall


Check installed versions - Failed

---

The SQL Backup extended stored procedure DLL version is 6.3.0.48, and 6.4.0.56 was expected.

Click 'Retry' to reinstall the server components. If this problem persists, it may be necessary to uninstall the server components manually, and then reinstall by running SQBServerSetup.exe on the server. See red-gate.com/sqbmanualinstall


Check SQLBackup extended stored procedures - Successful

---

Click 'Retry' to reinstall the server components. If this problem persists, it may be necessary to uninstall the server components manually, and then reinstall by running SQBServerSetup.exe on the server. See red-gate.com/sqbmanualinstall


Delete setup file from server - Successful

---

Click 'Retry' to reinstall the server components. If this problem persists, it may be necessary to uninstall the server components manually, and then reinstall by running SQBServerSetup.exe on the server. See red-gate.com/sqbmanualinstall


Verifying Installation - Failed

---

Click 'Retry' to reinstall the server components. If this problem persists, it may be necessary to uninstall the server components manually, and then reinstall by running SQBServerSetup.exe on the server. See red-gate.com/sqbmanualinstall

brosato

Can't even run it locally. Can't replace xp_sqlbackup.dll :evil:

peter.peart

Hi there,

Sorry you are running into this. The sure fire way to install the server side components is to perform this manually.

To do can follow the instructions detailed on the below link for manual installation (about 2/3rds of the way down the page):

http://www.red-gate.com/supportcenter/C ... 923310.htm

If you are still having issues, then this is more than likely because SQL Server is not releasing that particualr dll. This is particularly prevalent with SQL Server 2000, but has been known in 2005 and 2008. The way to resolve this is as follows:

If SQL Server Service cannot be stopped:

1. Find the Version 6.4 of xp_sqlbackup.dll (a copy can be found in the SQL Backup 6.4 installation folder)
2. Copy it somewhere else
3. Rename the copied file from step 2, e.g. xp_sqlbackup64.dll
4. Stop the SQL Server Agent
5. Run:

DBCC xp_sqlbackup(FREE)
EXEC sp_dropextendedproc sqlbackup
EXEC sp_dropextendedproc sqbstatus
EXEC sp_dropextendedproc sqbutility
EXEC sp_dropextendedproc sqbmemory
EXEC sp_dropextendedproc sqbdata
EXEC sp_dropextendedproc sqbdir
EXEC sp_dropextendedproc sqbtest
EXEC sp_dropextendedproc sqbtestcancel
EXEC sp_dropextendedproc sqbteststatus

6. Find the renamed version from step 3, e.g. xp_sqlbackup64.dll and copy this to the SQL Server instance BINN folder.
7. Run:

sp_addextendedproc sqlbackup, “xp_sqlbackup.dll”
sp_addextendedproc sqbstatus, “xp_sqlbackup.dll”
sp_addextendedproc sqbutility, “xp_sqlbackup.dll”
sp_addextendedproc sqbmemory, “xp_sqlbackup.dll”
sp_addextendedproc sqbdata, “xp_sqlbackup.dll”
sp_addextendedproc sqbdir, “xp_sqlbackup.dll”
sp_addextendedproc sqbtest, “xp_sqlbackup.dll”
sp_addextendedproc sqbtestcancel, “xp_sqlbackup.dll”
sp_addextendedproc sqbteststatus, “xp_sqlbackup.dll”

8. Start the SQL Server Agent

If SQL Server Service can be stopped:

1. Open a new query windows in SQL Server Management Studio (SQL Server 2005) or Query Analyzer (SQL Server 2000)
2. Type the following:

DBCC xp_sqlbackup(FREE)
EXEC sp_dropextendedproc sqlbackup
EXEC sp_dropextendedproc sqbstatus
EXEC sp_dropextendedproc sqbutility
EXEC sp_dropextendedproc sqbmemory

3. Stop the SQL Server Service.
4. Find all previous versions of xp_sqlbackup on your system and remove them including the installation folder.
5. Find xp_sqlbackup.dll (a copy can be found in the SQL Backup installation folder) and copy this to the SQL Server instance BINN folder.
6. Start the SQL Server Service.
7. Reinstall the SQL Backup server components.

HTH!

Pete

ITman

I'm having similar problems when trying to install on SQL2000 SP4 (w2k3 server). I get the following errors when I run the SQL commands in step 5.

~~~~~~~~~~~~~~~

DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Server: Msg 3701, Level 11, State 5, Procedure sp_dropextendedproc, Line 18
Cannot drop the procedure 'sqlbackup', because it does not exist in the system catalog.
Server: Msg 3701, Level 11, State 5, Procedure sp_dropextendedproc, Line 18
Cannot drop the procedure 'sqbstatus', because it does not exist in the system catalog.
Server: Msg 3701, Level 11, State 5, Procedure sp_dropextendedproc, Line 18
Cannot drop the procedure 'sqbutility', because it does not exist in the system catalog.
Server: Msg 3701, Level 11, State 5, Procedure sp_dropextendedproc, Line 18
Cannot drop the procedure 'sqbmemory', because it does not exist in the system catalog.
Server: Msg 3701, Level 11, State 5, Procedure sp_dropextendedproc, Line 18
Cannot drop the procedure 'sqbdata', because it does not exist in the system catalog.
Server: Msg 3701, Level 11, State 5, Procedure sp_dropextendedproc, Line 18
Cannot drop the procedure 'sqbdir', because it does not exist in the system catalog.
Server: Msg 3701, Level 11, State 5, Procedure sp_dropextendedproc, Line 18
Cannot drop the procedure 'sqbtest', because it does not exist in the system catalog.
Server: Msg 3701, Level 11, State 5, Procedure sp_dropextendedproc, Line 18
Cannot drop the procedure 'sqbtestcancel', because it does not exist in the system catalog.
Server: Msg 3701, Level 11, State 5, Procedure sp_dropextendedproc, Line 18
Cannot drop the procedure 'sqbteststatus', because it does not exist in the system catalog.

peter.peart

Hi there,

I am guessing this is step 5 of when the instance cannot be stopped? Can you try re-running SQBServerSetup.exe a couple of times to see if you can persist the installation that way?

If not, let me know.

Many thanks,

Pete

ITman

It was generating similar error messages whichever method I tried.

I ran SQBServerSetup.exe manually and this did sort it.

peter.peart

Glad to hear it's now working for you!

Pete