Sql server managment studio not opend in windows 10 after visual studio 2010 installed

abc 41 Reputation points

Hello All,
I have installed sql server 2012 on windows 10 64 bit. After that my sql server opened properly also database created successfully.
Then I have installed visual studio 2010 on same PC.But now I am not able to see visual studio 2010 on start menu.
Also I am not able to open sql server.while opening sql server i received following error window69486-img-20210218-wa0009.jpg69508-img-20210218-wa0009.jpg.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
11,586 questions
{count} votes

Accepted answer
  1. Olaf Helper 36,006 Reputation points

    SSMS is a plugin for Visual Studio, you see it in the splash screen, when you start SSMS: "Powered by Visual Studio"

    As the message say, you have to patch VS with SP 1, the only valid link (2010 is very old) is

2 additional answers

Sort by: Most helpful
  1. Erland Sommarskog 92,956 Reputation points

    You can download the most recent version of SSMS here: https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms
    This version is built on the shell for Visual Studio 2017, so it will not clash with your VS 2010 installation.

    1 person found this answer helpful.
    0 comments No comments

  2. CathyJi-MSFT 21,056 Reputation points Microsoft Vendor

    Hi @abc ,

    SSMS 2012 relies upon the Microsoft Visual Studio 2010 Shell (Isolated) Redistributable Package.

    As Erland mentioned, suggest you using the latest version SSMS 18.8, it relies upon the Microsoft Visual Studio 2017 Shell. Microsoft Visual Studio 2017 Shell will be installed automatically when install SSMS 18.8. SSMS can be installed side by side, you can also using SSMS 18.8 connect to SQL server 2012.

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

    0 comments No comments