Uninstall completely all versions of MS SQL in our computer

jana
jana used Ask the Experts™
on
We want to uninstall, delete and remove all traces of MS SQL2008.  We noticed that the Uninstall Programs in Control Panel has over 20 apps installed of MSSQL (including a 2012 version):

sqls


Please advice how to uninstall MSSQL, which should we "right-click >> uninstall" first, etc.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Author

Commented:
Note:
We have upgrade the WIndows 8 PC recently to Windows 10.
Nakul VachhrajaniTechnical Architect, Capgemini India

Commented:
If I am not mistaken, all you need to do is load the respective media (SQL 2008/2012, etc) and it will have an option to repair or remove the SQL Server instance. It will take care of uninstalling all the features that were initially installed when installing the respective instance.

Uninstalling from Add/Remove has the risk that it may be done out of order or it might miss a few components.

Author

Commented:
But the media are the actual downloads from Microsoft (all MSSQL installed are Express versions).  Do you mean run the installs again?
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Technical Architect, Capgemini India
Commented:
If you have SQL Server express, this approach won't work. Please follow the instructions in the MSDN documentation [https://msdn.microsoft.com/en-IN/library/ms143412.aspx] and you should be all set.
Arifhusen AnsariBusiness Intelligence Developer and Analyst
Top Expert 2015
Commented:
Hi rayluvs,

I have attached the screen shot. And if you want to uninstall all the instance of SQL 2008 r2.

Please try uninstalling the instance i have bordered with black.
Hope it will hep
sq2008uninstall.jpg
Jason clarkDBA Freelancer
Commented:
When you try to install Microsoft SQL Server 2008 on a server, the installation fails. http://support.microsoft.com/kb/955404

This article describes how to uninstall a stand-alone instance of Microsoft SQL Server 2008 http://support.microsoft.com/kb/955499

This article describes how to manually uninstall a stand-alone instance of Microsoft SQL Server http://support.microsoft.com/kb/909967

Author

Commented:
Ok, thanx for all comments, will try.

Author

Commented:
Read the links, why does it recommend prior uninstall to "Delete the local security groups"? What's the purpose?
Arifhusen AnsariBusiness Intelligence Developer and Analyst
Top Expert 2015

Commented:
Did you try to uninstall in directly from the Uninstall program?

Author

Commented:
There is no uninstall program found; we uninstalled via Control Panel as recommended by the links provided.

But why does the links recommend prior uninstall to "Delete the local security groups"?

Author

Commented:
We just uninstall SQL 2008 via Control Panel.  There still SQL 2012 and other non-2012 such as 'Server Compact', 'Data Tools', 'Database Publishing', etc. (see pix below)

pixsql
Any specific order to uninstall the still installed SQL apps? Which should we uninstall first, second, etc.?
PortletPaulEE Topic Advisor
Most Valuable Expert 2014
Awarded 2013
Commented:
>>"why does the links recommend prior uninstall to "Delete the local security groups"?"

because, typically, a dbms server will have special security arrangements - and the instructions are making sure you don't forget to clean-up the security.

Author

Commented:
Thanx!

What about our entry ID: 41387397? About the still present SQL 2012 and other non-2012 SQL components even though we ran the process of uninstall thru add/remove?

Please Advice on that?
PortletPaulEE Topic Advisor
Most Valuable Expert 2014
Awarded 2013

Commented:
Sorry. I have no experience with that uninstall problem and hence cannot provide further assistance. I offered an opinion on your "subquery" regarding security - that is all.

Author

Commented:
Understood.

Thank you.

Author

Commented:
Hi,

We are almost done completely uninstalling all MS SQL products.  The SQL2008 was uninstalled as recommended by EE successfully.  However there are 2 types of MS SQL products still installed:

There still SQL 2012 products (see pix belos)
ALso the other non-2012 such as 'Server Compact', 'Data Tools', 'Database Publishing', etc. (see pix below)
(haven't unistalled these because maybe there were part of the Windows 10 upgrade?)

This is what we have at this point:
sqlfinails

Note:
We can go and uninstall all of them, but as said above, the version that has no 2012 we dodn't know if there are part of another Windows 10 installation and important for that.

Please advice.
Vitor MontalvãoIT Engineer
Distinguished Expert 2017
Commented:
Start by uninstalling MSSQL 2012 Express LocalDB and then the Compact versions.
After that uninstall MSSQL Data Tools and what stays are only client tools and you'll need to uninstall them one by one.

Author

Commented:
Thanx!  Will do!

Author

Commented:
Worked!  After uninstalling, no SQL apps is found in Windows 10 Uninstall Programs windows.

Thanx!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial