yesterday I have an update for windows version 1909, after updating to the latest version, When I tried to open SSMS it shows me an error like this(please check the screenshot).
-
Did you try following the instructions and re-installing SSMS? Could possibly just do a "repair" install.– Jonathan FiteFeb 26, 2020 at 13:19
-
@JonathanFite yes I tried many times .– Dhanil DinesanFeb 26, 2020 at 13:20
-
Now what I am going to do is uninstall visual studio and ssms, then reinstall VS then install ssms.Let me try with this– Dhanil DinesanFeb 26, 2020 at 13:21
-
1two options, 1) Install Microsoft Visual C++ 2015 Redistributable, 2) Upgade to a newer version from SQL Server Management Studio 18.4– LuukFeb 26, 2020 at 15:34
-
@Luuk I installed SSMS 18.4 and it works fine– Dhanil DinesanFeb 27, 2020 at 6:27
|
Show 2 more comments
1 Answer
Two options:
- Install "Microsoft Visual C++ 2015 Redistributable"
From some reason the link that worked yesterday now does not work (thank you Microsoft!). The working link is The latest supported Visual C++ downloads
- Upgade to a newer version from SQL Server Management Studio 18.4
SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. SSMS provides tools to configure, monitor, and administer instances of SQL Server and databases. Use SSMS to deploy, monitor, and upgrade the data-tier components used by your applications, and build queries and scripts. Use SSMS to query, design, and manage your databases and data warehouses, wherever they are - on your local computer, or in the cloud. SSMS is free!
My, personal opinion, choose option2. SSMS 18.4 is available since 4 November 2019 and has (AFAIK) the same functionality compared to SSMS 17.x
