NetWorker : Installing NMM 19.9 on SQL Server with SSMS 19.1 Does Not Display in Toolbar
Summary: NetWorker Module for Microsoft (NMM) 19.9 installation on SQL Server that has SQL Server Management Studio 19.1 (SSMS) does not display in SSMS toolbar.
This article applies to
This article does not apply to
This article is not tied to any specific product.
Not all product versions are identified in this article.
Symptoms
The NetWorker Module for Microsoft 19.9 installation on SQL Server that has SSMS 19.1 does not display in SSMS toolbar.
- NMM 19.9 installation on SQL Server that has SSMS 19.1 does not display in SSMS toolbar.
- The Actual plug-in is successfully installed.
- The plug-in can be launched from the Start menu shortcut, and it backs up successfully.
Cause
The root cause of the issue is the use of VSIXInstaller to install SQL Server Management Studio extensions, which is no longer supported by Microsoft since SSMS version 18.x.
- Microsoft has discontinued the use of VSIXInstaller with SSMS 18.x and later versions.
- This change affects the installation and display of extensions, including the NetWorker Module for Microsoft (NMM) 19.9, in the SSMS toolbar.
- The issue is not related to the actual installation of the plug-in, which can be launched from the Start menu shortcut and backs up successfully.
- The problem lies in the fact that the plug-in does not appear in the SSMS toolbar due to the change in the installation process.
Caution: This issue is specific to SSMS 18.x and later versions, and users with earlier versions of SSMS may not experience this problem.
References: Microsoft article Install Extensions in SQL Server Management Studio (SSMS)
Resolution
The resolution to the issue may be available in a future release of NetWorker Module forMicrosoft.
The current resolution involves a workaround of creating a package definition file and copying the necessary files to the correct location.
Use the following workaround until a resolution can be integrated into the release of NetWorker/NMM.
Note: This resolution is a workaround and may not be applicable in future versions of SQL Server Management Studio.
The current resolution involves a workaround of creating a package definition file and copying the necessary files to the correct location.
Use the following workaround until a resolution can be integrated into the release of NetWorker/NMM.
- Copy files:
From: C:\Program Files\EMC NetWorker\nsr\bin\plugin\ To: C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE\Extensions\
- Create a package definition file:
Named: NWSSMSVSIXPackage.pkgdef In the folder: C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE\Extensions\
With the following contents in the file (formatting specific):
[$RootKey$\InstalledProducts\NWSSMSPackage]
@="#110"
"Package"="{89089cd1-c652-42b2-8fd1-209e9ade1a2c}"
"PID"="1.0"
"ProductDetails"="#112"
"LogoID"="#400"
[$RootKey$\Packages\{89089cd1-c652-42b2-8fd1-209e9ade1a2c}]
@="NWSSMSVSIXPackage.NWSSMSPackage, NWSSMSVSIXPackage, Version=1.0.5.0, Culture=neutral, PublicKeyToken=null"
"InprocServer32"="$WinDir$\SYSTEM32\MSCOREE.DLL"
"Class"="NWSSMSVSIXPackage.NWSSMSPackage"
"CodeBase"="$PackageFolder$\NWSSMSVSIXPackage.dll"
[$RootKey$\AutoLoadPackages\{adfc4e64-0397-11d1-9f4e-00a0c911004f}]
"{89089cd1-c652-42b2-8fd1-209e9ade1a2c}"=dword:00000000
[$RootKey$\Menus]
"{89089cd1-c652-42b2-8fd1-209e9ade1a2c}"=", Menus.ctmenu, 1"
- Some editing tools like Notepad, do not retain the required format.
- When creating the package definition file, use the attached file NWSSMSVSIXPackage.pkgdef instead of creating it manually to ensure the correct formatting.
- After creating the package definition file, restart the SQL Server Management Studio to apply the changes.
- Verify that the NetWorker Module for Microsoft is displayed in the SQL Server Management Studio toolbar.
Note: This resolution is a workaround and may not be applicable in future versions of SQL Server Management Studio.
Article Properties
Article Number: 000216455
Article Type: Solution
Last Modified: 31 Oct 2024
Version: 3
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.