SQL Server Management Studio 18.10 fresh install on new server, DdsShapes.dll problem

Duncan 56 Reputation points
2022-02-05T15:47:08.863+00:00

Activation context generation failed for "C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe". Dependent Assembly "DdsShapes.dll,processorArchitecture="X86",type="win32",version="1.0.0.0"" could not be found. Please use sxstrace.exe for detailed diagnosis.

ERROR Event ID 33 SideBySide

What went wrong? New Server 2019, fresh install of SQL Server 2017 with Advanced Services, installed SQL Server Management Studio 18.10 -> got this error.

SQL Server | Other
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Duncan 56 Reputation points
    2022-02-05T19:24:47.383+00:00

    The correct solution is:

    1. uninstall SQL Server Management Studio 18.10, cause its installation process is bugged.
    2. install SQL Server Management Studio 18.9.2 (15.0.18386.0 / July 15, 2021)
    3. re-install SQL Server Management Studio 18.10

    No errors in Event log and DdsShapes.dll is now present as 18.9.2 is installing this dll, which is NOT present in 18.10.

    Someone should drop a note on the SSMS homepage that 18.10 is NOT suitable for fresh installations, only for upgrades.

    1 person found this answer helpful.

  2. Ronen Ariely 15,206 Reputation points
    2022-02-05T16:59:52.36+00:00

    Hi,

    (1) Do have Visual Studio installed on the same machine?

    (2) Make sure that you install the SSMS as administrator - restart machine and try again

    (3) Did you saw and try to do what the error message suggests Please use sxstrace.exe for detailed diagnosis?

    The sxstrace.exe is a small utility which assists in diagnosing side-by-side errors. It should run in the background while you try to the action and it collect information. In your case, you start it before you try to install the SSMS -> install the SSMS (until succeed or fails) -> stop the sxstrace.exe and collect the information from the log it wrote.

    • create new folder to store the log: C:\RonenArielyTraceTest
    • run the utility: sxstrace.exe Trace -logfile:C:\RonenArielyTraceTest\RonenArielyTraceTest.log
    • try to install the SSMS again (the sxstrace utility should collect information in the background)
    • stop the sxstrace depend on how you started it (in powershell you simply click Enter or you might need to run sxstrace.exe stoptrace)
    • The log file is a binary file which hard to parse manually so we will use the same tool to parse the file. execute the command: sxstrace.exe Parse -logfile:C:\RonenArielyTraceTest\RonenArielyTraceTest.log -outfile:C:\RonenArielyTraceTest\RonenArielyTraceTest.txt

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.