Avatar of Joe Brown
Joe Brown
Flag for United States of America asked on

SQL Server Management Studio install Error - JoeB

I uninstalled SSMS and attempted to reinstall SSMS.   Now getting these errors in my event viewer when reinstalling SSMS or attempting to run SSMS.

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

Source: MSSQLSERVER
Login failed for user 'IN\XXXXXXXXXX$'. Reason: Could not find a login matching the name provided. [CLIENT: <local machine>]

InstallationMicrosoft SQL Server

Avatar of undefined
Last Comment
Joe Brown

8/22/2022 - Mon
Bembi

I would assume, you should add the user account, which has startet the setup to the sysadmin role of SQL Server. 
Joe Brown

ASKER
Thank you Bembi for your reply  -  My first statement above is a little miss leading after re-reading it.   SSMS is not on my laptop.   I uninstalled SSMS and attempting to re-install SSMS.   I am getting the error on the re-install.  


Peter Chan

Hi,
Do you have MS SQL express on the machine? Sometimes, if you have other software like Active Dir, it could lead to issue that you cannot install or uninstall SQL server properly.
Your help has saved me hundreds of hours of internet surfing.
fblack61
Joe Brown

ASKER
Thanks Peter,   I have SQL Server Developer install and not SQL Express.    I am working on installing SQL Express to see if that works.
Bembi

Hi Joe,
yes, I understood, but I meant the machine on which you want to install it as well as the account which you use to install it.
For installation purposes you should usually be local admin (on the machine) as well as having the sysadmin role in SQL.

Hello There

Did you reboot the computer after you uninstalled it? Did you clean up leftover folders in C:\ProgramData and C:\Program Files? Do this and then try it again.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Andrei Fomitchev

Did you run the setup as administrator?
ASKER CERTIFIED SOLUTION
Joe Brown

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.