x

Uninstall last default SQL 2005 Instance

Hi All,

I want to Uninstall last default SQL 2005 Instance from the server. However, I do need to keep the SQL Server client tools (like Management Studio) on the server.

If I select just Database engine during Uninstall, only SQL instance will be removed , right? I can still retain the SQL client tools..am I correct? ![alt text][1]

What will this selection unistall - database engine only or also client tools? (I have selected the SQL instance - MSSQLSERVER and then database engine)

Thanks in advance..

[1]: /upfiles/uninstall.JPG
more ▼

asked Sep 23, 2011 at 04:03 AM in Default

Mandar Alawani gravatar image

Mandar Alawani
376 33 39 44

When you highlight each of those nodes in your picture, the details of that node are displayed on the right side under "Feature Description", the "Shared Tools" node should be where SSMS is contained. Leave that out of the uninstall process to keep it installed.
Sep 23, 2011 at 05:02 AM WilliamD
But if I leave out that shared tools, even the data files gets deselected...does that mean that the database engine will also remain?
Sep 23, 2011 at 05:05 AM Mandar Alawani
(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first
Correct, the client tools are a separate entity all together. If you choose to uninstall SQL Server, then the server will be removed, but the client tools will remain installed.
more ▼

answered Sep 23, 2011 at 04:14 AM

WilliamD gravatar image

WilliamD
25.9k 17 19 41

Thanks...sorry to confirm it again...When I select database services --> saying Entire feature will be uninstalled, even then the Client tools will remain?... and this is the Last default instance on the server..
Sep 23, 2011 at 04:24 AM Mandar Alawani
You choose the components to remove, just like when installing you choose the components to install.
Sep 23, 2011 at 04:39 AM WilliamD
(comments are locked)
10|1200 characters needed characters left
You will have a choice of what components to uninstall just like you had choices of what to install. Simple choose what you want to remove and you are good to go.
more ▼

answered Sep 23, 2011 at 04:19 AM

Tim gravatar image

Tim
36.4k 39 41 139

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1951
x6
x5

asked: Sep 23, 2011 at 04:03 AM

Seen: 1012 times

Last Updated: Sep 23, 2011 at 04:57 AM