how to identify whether SQL plug-in (CvSQLAddInConfig.exe) is configured or not, without login and checking from SSMS on servers ?
Best answer by Allan0105
View originalhow to identify whether SQL plug-in (CvSQLAddInConfig.exe) is configured or not, without login and checking from SSMS on servers ?
Best answer by Allan0105
View originalHi
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
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.
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.
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”
Hi Scott, tried couple of servers but no luck, may be am i missing the path ?
Hi Scott, tried couple of servers but no luck, may be am i missing the path ?
Hi
Let me know once you get the incident created.
Thanks!
Thanks!
Hi Mike, i missed track on this. i will get one case opened and keep you updated.
Any progress you can share on this one?
Thanks!
Any progress you can share on this one?
Thanks!
Hi mike, here we go 220909-458!
Have a great weekend!
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,
Might be worth asking if a CMR is a possibility….
Sure!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.