Microsoft Sql Server Management Studio Console will not open after installing.

Problem

Solution

In certain cases the MSSQL server studio will not open.. .follow these approved steps from Microsoft to resolve. 

1. Simply remove the file C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\CommonExtensions\Platform\Microsoft.VisualStudio.MinShell.Interop.pkgdef

   Anyhow, several days ago the team publish an update as you can see in the link above. This is a quote from the official updated response:

   The recommended workaround, in the interim, is:

   1) Close all instances of SSMS

   2) Edit ssms.exe.config

   3) Remove the line that has the following text (should be line 38): NgenBind_OptimizeNonGac enabled=“1”

   That’s the same change that will be in the next release of SSMS 18.x

   Note! the location of ssms.exe.config file is in the folder: C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE

Related articles

• Page:
  MSSQL Server and Client Configuration Recommendations and Requirements
• Page:
  How to remove MSSQL records associated with a failed dataset migration or dataset copy - Generate Delete Data from All Tables by TenantID
• Page:
  MSSQL How To find the active connections to the database. (system or users)
• Page:
  MSSQL Transaction Timeout and Rollback
• Page:
  MSSQL Maximum server memory setting - How do I determine if MSSQL is using too much memory or storage space?