SSMS 18 will not start. What does this error mean (and how can I fix it)?

Keith McIntyre 1 Reputation point
2021-04-14T06:49:36.463+00:00

I just installed SQL Server 2019 Developer Edition and SSMS 18.

When I start SSMS 18, the splash screen displays for a moment then goes away. TaskManager does not show the app running.

The log file shows the following error. <entry> <record>44</record> <time>2021/04/14 03:06:10.659</time> <type>Warning</type> <source>VisualStudio</source> <description>Performance warning: String load failed. Pkg:{39C9C826-8EF8-4079-8C95-428F5B1C323F} LANG:0409 ID:2143&#x000D;&#x000A;</description> </entry> </activity>

Searching the web, it appears the package is related to Visual Studio 2010?

I have no idea how to fix this.

I assume I need a replacement file. Any ideas which file? Any ideas where I get get the version that works with SQL2019 and SSMS 18?

Thanks for helping an old blind guy out...

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,756 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 40,901 Reputation points
    2021-04-14T10:17:32.59+00:00

    SSMS is a plugin for Visual Studio, that's why VS is reported in error message.

    You could repair VS or install/update latest version from Download SQL Server Management Studio (SSMS)

    0 comments
  2. Keith McIntyre 1 Reputation point
    2021-04-14T16:41:58.137+00:00

    I ...JUST... downloaded both SQL Server Developer 2019 and SSMS 18.8 from the Microsoft website yesterday. I installed without error. SSMS fails to get past the splash screen..

    I checked the SSMS page mentioned above. There is no link that I could find for installing Visual Studio.

    I do not believe I installed VS on this computeer since I last whacked it. So whatever VS redistributable bits are on my SSD came from some other installation program.

    I will try installing the latest Visual Studio Express and see if that helps.

    To me, this seems to be a Microsoft installer issue...

    Thanks

  3. CathyJi-MSFT 21,096 Reputation points Microsoft Vendor
    2021-04-15T07:19:51.487+00:00

    Hi @Keith McIntyre ,

    > When I start SSMS 18, the splash screen displays for a moment then goes away.

    Please copy the file: Microsoft.VisualStudio.Shell.Interop.8.0.dll
    from the directory: C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\PrivateAssemblies\Interop
    into the directory: C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\PublicAssemblies
    ,then SSMS should start behaving.

    If it is still not work, please try below steps;

    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”

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

    Quote from the thread SQL Server Management Studio 18 won't open (only splash screen pops up) and MS feed back SSMS2018 - Installed, but will not run.

    If the response is helpful, please click "Accept Answer" and upvote it, thank you.