Yes, no Oracle today. A very short blogpost about opening SQL Server Management Studio. It didn’t open, only a splash screen pops up.
Found the solution at DBA Stack Exchange, but thought it would be nice to summarize this in a blog-post.
Logging gave no clue:
- Running ssms.exe with logging (C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe” -log C:\drop\log.txt)
- C:\Users(user)\AppData\Roaming\Microsoft\AppEnv\15.0\ActivityLog.xml .
Solutions mentioned (first one worked for me):
- “I just overlaid the Microsoft.VisualStudio.Shell.Interop.8.0.dll in
C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\PublicAssemblies
with the copy from..\PrivateAssemblies\Interop
and the IDE opens” - Another solution: “For me there was an additional
Microsoft.VisualStudio.Shell.Interop.8.0
“
This is known issue and there is new official workaround which published by the SSMS developers team.
You can view the open ticket at the Microsoft feedback system .
Resources:
DBA stack exchange: https://dba.stackexchange.com/questions/237086/sql-server-management-studio-18-wont-open-only-splash-screen-pops-up
Microsoft feedback system: https://feedback.azure.com/forums/908035-sql-server/suggestions/37502512-ssms2018-installed-but-will-not-run
Leave A Comment