Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Microsoft SQL Server Management Studio Opening Error

Tags:

sql-server

visual-studio-2010

I installed SQL Server Management Studio and it worked fine. After that I updated my Visual Studio from 2010 to 2013 Express edition, now it is not working with this error message :

Cannot find one or more components. Please re install the application

I re-installed it but still same issue. Any suggestion?

like image 223
Ali Malik Avatar asked Jan 17 '15 11:01

Ali Malik

People also ask

How do I reinstall SQL Management Studio?

Note: If you do not have SQL Server 2012 installed on your machine, select ENU\x64\SQLEXPRWT_x64_ENU.exe (or ENU\x86\SQLEXPRWT_x86_ENU.exe for 32-bit) to download and install both SQL Server 2012 and Management Studio in a bundle. After the download is completed, run the .exe file as Administrator.

How do I repair Microsoft SQL?

Launch the SQL Server Setup program (setup.exe) from SQL Server installation media. After prerequisites and system verification, the Setup program will display the SQL Server Installation Center page. Click Maintenance in the left-hand navigation area, and then click Repair to start the repair operation.

Why SSMS is not installing?

Run the Microsoft Installation Cleanup Utility to remove the rogue client tools still existing on the server, which are not listed in Add or Remove Programs. Reinstall the client components again. This time, the installer should perform a proper install of the Management Tools, including SQL Server Management Studio.

1 Answers

The SQL Server 2014 Management Studio answer

SSMS 2014 relies upon the Microsoft Visual Studio 2010 Shell (Isolated) Redistributable Package. If this is uninstalled, SSMS will produce the error message 'Cannot find one or more components. Please re install the application'. This can be corrected by:

  1. Reinstalling the VS 2010 Shell from here: https://visualstudio.microsoft.com/vs/older-downloads/isolated-shell/
  2. Try opening SSMS again. If it still gives the error, then:
  3. Run Repair in SQL Server (2014) Setup

The SQL Server 2016 Management Studio answer

SSMS 2016 relies upon the Microsoft Visual Studio 2015 Shell (Isolated) Redistributable Package. If this is uninstalled, SSMS will produce the error message 'Cannot find one or more components. Please re install the application'. This can be corrected by reinstalling VS 2015 or by installing the Microsoft Visual Studio 2015 Shell (Isolated) Redistributable Package.

like image 141
Rikard Askelöf Avatar answered Nov 15 '22 23:11

Rikard Askelöf
Sign in to Comment

Related questions

Compare dates in T-SQL, ignoring the time part
T-SQL Throw Exception
SQL Server Group by Count of DateTime Per Hour?
Find non-ASCII characters in varchar columns using SQL Server
Passing a varchar full of comma delimited values to a SQL Server IN function
Search and replace part of string in database
How to check if a string is a uniqueidentifier?
SQL Server - Convert date field to UTC
What is a Trusted Connection?
What's the right way to compare an NTEXT column with a constant value?
What is the LDF file in SQL Server?
How can I lock a table on read, using Entity Framework?
How can I force entity framework to insert identity columns?
Why & When should I use SPARSE COLUMN? (SQL SERVER 2008)
How to return a incremental group number per group in SQL
What is "Connect Timeout" in sql server connection string?
How to detect if a string contains at least a number?
Select a column if other column is null
Get the time of a datetime using T-SQL?
How to add a new schema to sql server 2008?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!