Share via

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

abc 41 Reputation points
2021-02-18T12:07:26.44+00:00

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.
13,793 questions
Accepted answer
  1. Olaf Helper 44,501 Reputation points
    2021-02-18T12:24:41.773+00:00

    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
    https://download.cnet.com/Microsoft-Visual-Studio-2010-Service-Pack-1/3000-2070_4-75451099.html

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 111.1K Reputation points MVP
    2021-02-18T22:32:59.717+00:00

    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
  2. CathyJi-MSFT 22,201 Reputation points Microsoft Vendor
    2021-02-19T05:48:00.77+00:00

    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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.