[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1374
  • Last Modified:

How to completely remove SQL server from my PC

I received a PC. I had Windows XP and I upgraded to Windows Vista Ultimate. I installed SQL server 2000 on it using a default instance and When I wanted to open the Quedry analyzer it couldn't open the server. I went to check in Enterprise Manager, I noticed that there were two servers in the server group. The "Local" and another server name. I understood that tere was another SQL server installed on the PC. I asked the person who sold me the PC, he told me that He had SQL Server 2005 installed on it and then he uninstalled it. I tried to uninstall the SQL Server 2000 I installed then I deleted the SQL folders in Program files. And then tried to install again, I still have the same problem. The Sql server seems to want to connect to the server of the SQL server 2005 that was previously installed. In the Enterprise Manager, the two server name are still there.
What can I do to completely remove SQL Server from the PC so I can installed my own server.
0
chriska
Asked:
chriska
2 Solutions
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you can remove the registration in the enterprise manager, just right-click and delete...
0
 
SharathData EngineerCommented:
To remove all SQL Server components, try this
execute the below command from the command prompt,

CD %ProgramFiles%\Microsoft SQL Server\100\Setup Bootstrap
Setup100.exe /q /Action=Uninstall /FEATURES=SQL,AS,RS,IS,Tools /INSTANCENAME=MSSQLSERVER

go to that location and check what are all the folder you have like 80,90 and 100.
Try to uninstall all by chaniging the folde name in the above command.

Then via Add-Remove, uninstall SQLXML4 and SNAC if They do not get uninstalled by above command.

Verify no more SQL components are left in the Add-Remove.

Hope this will help you.
 
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now