14,494 questions
Hi ,
Please go through below links, hope you may get help:
Regards,
How to resolve "reference Automation" issue when SSMS executes
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(217.60000000000002, 13%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERH%3C/text%3E%3C/svg%3E)
Robert Higgins
10
Reputation points
I am successfully running SQL Server 2022 on Win 10 (64-bit) with SSMS 18.12.1. I have downloaded & installed SSMS 19.3.4. and there were no reported errors during its installation. However, when executing SSMS.exe the msg "The application has failed to start because side-by-side configuration is incorrect". I am at a loss as to what to do next.
I ran sxstrace.exe whilst launching SSMS.EXE and have attached that output along with the current versions of software applicable to SSMS.
Looking at the last "Attempt to probe manifest ... " statements in the sxstrace output, I can confirm that there are no "Automation.*" files in the folder "C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE", and also that the folder C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE\Automation" does not exist. Is that my issue? If so, how can that be remedied?
I have repaired, uninstalled, installed Visual Studio, SSMS, redistibutables, etc. in an attempt to eliminate any possibility of corrupted files being the cause. All to no avail.
Happy to provide additional information. Can anyone provide me with some advice?
SQL Server | Other
{count} votes
-
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator2024-03-04T22:30:37.6933333+00:00 I have no idea how to deal with this, but I can confirm that I have a folder C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE\Automation on my machine. (Where I have SSMS 20, SSMS 19, SSMS 18 and some even older versions of SSMS.)
Sign in to comment
1 answer
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(307.2, 78%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZB%3C/text%3E%3C/svg%3E)
Zahid Butt 961 Reputation points2024-03-04T19:27:43.66+00:00 -
Robert Higgins 10 Reputation points
2024-03-05T15:25:26.67+00:00 Zahid Thanks for that. I have now tried what you have suggested without success. Furthermore, I have used DISM to repair Windows 10 image. After installing SSMS 19.3, I did a comparison of the IDE subfolders for each version as shown in the attachment. Whilst I appreciate the apps are different, It seems odd that I am missing a number of folders - particularly Automation which Erland has confirmed exists in 19.3.Comparison of SSMS ver 18 and ver 19 IDE subfolders.pdf
-
Robert Higgins 10 Reputation points
2024-03-07T10:12:40.03+00:00 After temporarily installing Hyper-V to see the resources SQL Server & SSMS 19.3 actually used, I uninstalled SSMS 19.3 and numerous older Visual C++ Redistributables to at least match the Hyper-V configuration. After cleaning the registry of all Management Studio 19 references, I finally (re)installed Win 10 keeping all my Apps etc. I now have SSMS 19.3 working.
As a footnote, Hyper-V has a lot to offer.
-
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator
2024-03-07T21:58:13.01+00:00 Glad to hear that you got things working, even if you have to spend a whole of time.
Yes, virtual machines are great.
Sign in to comment -