About Me

My photo
I am an MCSE in Data Management and Analytics, specializing in MS SQL Server, and an MCP in Azure. With over 19+ years of experience in the IT industry, I bring expertise in data management, Azure Cloud, Data Center Migration, Infrastructure Architecture planning, as well as Virtualization and automation. I have a deep passion for driving innovation through infrastructure automation, particularly using Terraform for efficient provisioning. If you're looking for guidance on automating your infrastructure or have questions about Azure, SQL Server, or cloud migration, feel free to reach out. I often write to capture my own experiences and insights for future reference, but I hope that sharing these experiences through my blog will help others on their journey as well. Thank you for reading!

A problem occurred when loading the Microsoft SQL Server Management Studio menu.

Issue:-

After SQL Server 2012 Enterprise edition installation, some time SSMS do not invoke and Error comes like


---------------------------
Microsoft SQL Server Management Studio
---------------------------
A problem occurred when loading the Microsoft SQL Server Management Studio menu. To fix this problem, run 'Ssms.exe /resetsettings' from the command prompt. Note: this command resets your environment settings.




Problem:
Because of some unknown issue installation do not proceed and we force to  cancel the installation then we run the setup from beginning but then also this issue persist.

Resolution:-


1) Go to installation folder of sql server where setup.exe exist
2) Uninstall Tools of SQl server unistallation
the command is :

setup.exe /action=uninstall /features=Tools /INSTANCENAME=SQL03

sql server setup wizard will invoke and it will display you to check the feature which need to
uninstall
3) select the tools part.
4) uninstallation part will proceed and tools will uninstall.

then Again run the command to install the Tools part of  MSSQL Server 2012

setup.exe /action=install /features=Tools /INSTANCENAME=SQL03