Comments
2 comments
-
Thank you for your post and sorry that you have encountered this problem.
When the SQL Backup Server components are installed, a registry key is added for each instance which has the path to the SQL Backup Agent executable.
For a named instance, the path should end with '-i <SQL Instance Name>', for some reason this parameter does not get added to the path and this is what I suspect has occurred.
Can you please check the following registry key for each SQL Backup Server Components installation to see if it has the '-i <SQL Instance Name>' parameter at the end of the path.
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLBackupAgent_<InstanceName>
You should see two folders, one for each instance.
Locate the ImagePath Key in each folder which is a REG_SZ type, check the data path and ensure that it has the '-i <SQL Instance Name>' parameter at the end of the path.
If it does not have the '-i <SQL Instance Name>' parameter, please modify the ImagePath key and add the '-i <SQL Instance Name>' parameter to the end of the path.
Missing the '-i <SQL Instance Name>' parameter:C:\Program Files(X86)\Red Gate\<InstanceName>\SQBCoreService.exe
With the '-i <SQL Instance Name>' parameter:C:\Program Files(X86)\Red Gate\<InstanceName>\SQBCoreService.exe -i <SQL Instance Name>
You may need to re-boot the server so that the change takes effect.
I hope that the above advice resolves your problem.
PLEASE NOTE The above advice only occurs on SQL Servers Instance's that are a named instances. The default or (local) instance do not require the '-i' parameter.
Many Thanks
Eddie -
That was it - Thanks
Add comment
Please sign in to leave a comment.
I have loaded the red-Gate gui and installed the agents for both instances but the services stay in a starting status. I see 2 SQBCoreService.exe*32 executables running in task manager with 0 cpu and I am unable to make a connection with the Red-Gate gui.
I have verified that both sql instances are up and running and I can make connections to them with the sql tools.
I have uninstalled the server components and used SQBServerSetup.exe to install the server components but the services still stay in a starting state.
Please advise
Thanks,