how to identify whether SQL plug-in (CvSQLAddInConfig.exe) is configured or not, without login and checking from SSMS on servers ?
Solved
how to identify whether SQL plug-in is configured or not, without login and checking from SSMS on servers ?
- Novice
Best answer by Allan0105
You as well!!
Below is the response from commvault engineer
Arun,
Thank you for your patience while I researched your request. I have tested this in my lab, and also discussed with a tier 2 engineer. Unfortunately there is not a way to tell whether the plug is enabled/configured without checking in SSMS (SQL Server Management Studio). In addition, jobs launched from the plug in are seen by the Commserve in the same way as a job launched from q-commands/command line, so backups launched from the plug in could also not be filtered out of a Job Summary Report to identify clients running backups in this way.
Please let me know if you have any further questions.
Thank you,
- Vaulter
Hi
This is an interesting question. Just curious is there a particular need to check this? What is the situation that you need to check if it's enabled without SSMS?
There is a DLL registration that gets confirmed when enabling it, but probably the simplest way to check is the registry. SSMS has a section for plugins.
I am not certain on this might need to check with MSFT but the following location I believe has a line per addin with value of 1 for enabled. This would have to be confirmed with MSFT however.
HKLM\Software\Microsoft\Microsoft SQL Server\verions\Tools\Shell\AddIns
- Novice
Hi
This is an interesting question. Just curious is there a particular need to check this? What is the situation that you need to check if it's enabled without SSMS?
There is a DLL registration that gets confirmed when enabling it, but probably the simplest way to check is the registry. SSMS has a section for plugins.
I am not certain on this might need to check with MSFT but the following location I believe has a line per addin with value of 1 for enabled. This would have to be confirmed with MSFT however.
HKLM\Software\Microsoft\Microsoft SQL Server\verions\Tools\Shell\AddIns
We are doing an automation to figure it out whether plug-in is enabled or not automatically.
- Vaulter
Okay thanks. Does the registry information help? If you are running a query or script remotely you should be able to query the reg info. FYI the plugin is always disabled by default and needs to be registered to enable on each individual server to be enabled.
- Novice
Okay thanks. Does the registry information help? If you are running a query or script remotely you should be able to query the reg info. FYI the plugin is always disabled by default and needs to be registered to enable on each individual server to be enabled.
Nope, i am not able to find this path “HKLM\Software\Microsoft\Microsoft SQL Server\verions\Tools\Shell\AddIns”
- Vaulter
- Novice
Hi Scott, tried couple of servers but no luck, may be am i missing the path ?
- Novice
Hi Scott, tried couple of servers but no luck, may be am i missing the path ?
Hi
+22- Vaulter
Let me know once you get the incident created.
+22- Vaulter
Thanks!
- Novice
Thanks!
Hi Mike, i missed track on this. i will get one case opened and keep you updated.
+22- Vaulter
Any progress you can share on this one?
Thanks!
- Novice
Any progress you can share on this one?
Thanks!
Hi mike, here we go 220909-458!
Have a great weekend!
- Novice
- Answer
You as well!!
Below is the response from commvault engineer
Arun,
Thank you for your patience while I researched your request. I have tested this in my lab, and also discussed with a tier 2 engineer. Unfortunately there is not a way to tell whether the plug is enabled/configured without checking in SSMS (SQL Server Management Studio). In addition, jobs launched from the plug in are seen by the Commserve in the same way as a job launched from q-commands/command line, so backups launched from the plug in could also not be filtered out of a Job Summary Report to identify clients running backups in this way.
Please let me know if you have any further questions.
Thank you,
+22- Vaulter
Awesome, keep me posted! Ideally, I want to save the CMR number in this thread for posterity.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.