how to thoroughly un-install a SQL server?

[#1]

Please provide the method. Thanks a lot!

Pints guaranteed.

[Former Member]

Hi,

1.Uninstall SQL Server 2000 Database and Analysis Services components from control panel -> add\remove programs2.Reboot the Server3.Delete the Microsoft Analysis Services & Microsoft SQL Server folders in Windows Explorer under X:\Program Files if available4.Delete the following keys from the registry if they exist: Hkey local machine\ Software\ Microsoft\ A)Microsoft SQL ServerB)MSSQLServerC)Olap ServerD)SQL Redist

Let me know if this helps

Rohit

[Former Member]

Thank you!

Your method is the simplest one I see.

Mine is a clustered SQL server on 2 nodes.

Could you tell whether your method is OK for both nodes?

Regards!

[Former Member]

Yes C Z,

you have to move all the services to one node and then uninstall and then follow it up for 2nd Node

Hope it helps

Rohit

[Former Member]

Thanks!

Here is my action plan:

1) move all services to node B

2) un-install SQLserver at node A

3) un-install SQLserver at node B.

Please help verify. Thanks!

[Former Member]

Hello C Z,

for a clustered node,follow this method:

To begin the uninstallation process, launch Add or Remove Programs in Control Panel.

Select the SQL Server 2005 component to uninstall, and then click Remove. This will launch the SQL Server 2005 Installation Wizard.

On the Component Selection page, select Remove SQL Server 2005 instance components and then click the instance name and common components to uninstall. To continue, click Next.

On the Remote Login Information page, provide the password for the administrator account on all nodes of the clustered instance. To continue, click Next.

On the Confirmation page, verify the selections for SQL Server components that will be removed. To continue with the uninstallation process, click Finish.

The SQL Server Installation Wizard will remove SQL Server 2005 components from your computer. If Setup requires access to the SQL Server 2005 installation media, you will be prompted to insert the CD or DVD into the CD or DVD drive. The CD or DVD used to uninstall SQL Server must have the same build number as the SQL Server instance you are trying to uninstall. For network installations, Setup must have access to the network build folder.

The SQL Server System Configuration Checker will scan your computer's existing configuration. On the Welcome page, click Next. After the System Configuration Checker finishes its scan, click Next to continue.

The Setup Progress page will display status as it removes SQL Server 2005 from your computer. On the Completing the Microsoft SQL Server Installation Wizard page, you can view the Setup summary log by clicking the link provided on this page. To exit the SQL Server Installation Wizard, click Finish.

Let me know if it helps

Rohit

[Former Member]

hello c z

did u check the last method,I think this one is more suitable

Please refer to this link:http://msdn.microsoft.com/en-us/library/ms190438(SQL.90).aspx

Rohit

[Former Member]

hello c z

did u try that?

was it successful

Rohit

[Former Member]

I will let you know once I am done. Thanks and regards.

[Former Member]

Rohit:

I did what you said. Nothing about SQL left at add/remove software panel.

Howevre, many SQL related entries still are there. Please help more. It must be clean

so that we can install others.

Thanks!!

[Former Member]

Hello C Z,

where can u find the entries

Rohit