How to completely remove SQL server from my PC

Posted on 2008-11-11
Last Modified: 2012-05-05
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.
Question by:chriska
    LVL 142

    Assisted Solution

    by:Guy Hengel [angelIII / a3]
    you can remove the registration in the enterprise manager, just right-click and delete...
    LVL 40

    Accepted Solution

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    In this article—a derivative of my blog post (—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
    JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now