Forum Discussion

JonCi90's avatar
JonCi90
Copper Contributor
Aug 01, 2023

Error when creating SQL Credential in SSMS 19

Hi all,   I recently installed SQL Server 22 CU4 and SSMS 19.1.56.0 on a new VM in Azure running Server 2022 Datacenter.   When attempting to setup a maintenance plan with a backup, I receive the...
Woody0's avatar
Woody0
Copper Contributor
Sep 01, 2023

I was able to resolve it in SSMS 19.1.56.0 by adding this snippet:

 

            <dependentAssembly>
                  <assemblyIdentity name="Microsoft.SqlServer.Management.AzureAuthenticationManagement" publicKeyToken="89845dcd8080cc91" culture="neutral"/>
                  <bindingRedirect oldVersion="1.0.0.0-16.0.0.0" newVersion="16.200.0.0"/>
              </dependentAssembly>

 

in the assemblyBinding section of the file:
C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE\Ssms.exe.config. note that the version numbers may vary based on your specific environment.