SQL Backup Agent Service not starting

Toeho

I have a 2 node cluster that I can not get the SQL Backup Agent service to start on. The services get created correctly in the cluster and on both nodes but when the installer tries to bring the service online it fails. I see a SQBCORESERVICE.exe running but the actual service stays in a "Starting" status and the cluster resource shows as failed.

Errors from the installer are:

IDXDW05\IDXDW05: Server Component Installation - Failed
=======================================================

Copy SQBServerSetup.exe to server - Successful

---

This operation completed successfully.


Run setup on server - Successful

---

This operation completed successfully.


Start SQL Backup Agent service - Failed

---

The SQL Backup Agent service cannot start, or is taking too long to start up.

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.



Check installed versions - Failed

---

Error opening mutex.


Check SQLBackup extended stored procedures - Successful

---

This operation completed successfully.


Delete setup file from server - Successful

---

This operation completed successfully.


Updating SQL Server information - Failed

---

Error opening mutex.

Eddie D

Thank you for your post into the forum and sorry that this problem has occurred.

I suspect that this is a named instance of SQL on your cluster, where the service is not starting correctly.

If this is a named SQL Instance, can you please check the following registry key on each node of the cluster has the -i <SQL Instance Name> at the end of the path specified:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLBackupAgent_<SQL Instance Name>

You will find a registry key called ImagePath.
The data value for this key is the path to the SQBCoreService.exe, does the path have the -i <SQL Instance Name> switch at the end of the path specified? If the answer is no, please add the -i <SQL Instance Name>.

For Example using a named instance called SQL2005

I locate the ImagePath Registry Key in the following Registry Folder path:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLBackupAgent_SQL2005

Upon checking the ImagePath key is does not have the -i parameter:
C:\Program Files\Red Gate\SQL Backup\SQL2005\SQBCoreService.exe

Add the -i parameter so the path becomes:
C:\Program Files\Red Gate\SQL Backup\SQL2005\SQBCoreService.exe -i SQL2005

Now attempt to start the SQL Backup Agent.

In some cases you may have to re-boot the server for the change to take effect.

Remember to perform the above on the other cluster nodes.

Many Thanks
Eddie