About Me

My photo
I am MCSE in Data Management and Analytics with specialization in MS SQL Server and MCP in Azure. I have over 13+ years of experience in IT industry with expertise in data management, Azure Cloud, Data-Canter Migration, Infrastructure Architecture planning and Virtualization and automation. Contact me if you are looking for any sort of guidance in getting your Infrastructure provisioning automated through Terraform. I sometime write for a place to store my own experiences for future search and read by own blog but can hopefully help others along the way. Thanks.

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