none
remove sql 2005 services from services.msc

    Question

  • hi,

    I have uninstall sql server 2005 ,delete default folder location ,reinstall IIS on server 2008 R2 .

    But still sql service is showing in services.msc in stop state , due to this I am not able to re_install default

    instance of sql server 2005 .

    please tell me how to remove service form services.msc and re_install sql default instance.


    Sunil Dahiya
    Wednesday, April 13, 2011 10:14 AM

Answers

  • you can remove the service using sc command:

     

    SC Command:

    DESCRIPTION: Deletes a service entry from the registry. If the service is running, or another process has an open handle to the service, the service is simply marked for deletion. USAGE: sc delete [service name]

     

    make sure you have un-installed SQLServer completed before deleting the service.

    you won't be able to get it back unless you reinstall.


    Vishal Gajjar
    Wednesday, April 13, 2011 10:35 AM
  • Hi Sunil,

    Could you please post the error message you are receiving?

     

    The clients are not installed on per-instance basis. It is common for all instances, you need to install them only once.

     

    can you check if you already have client components installed?

    you should be able to open SQLServer Management by using Start > Run > "SqlWb.exe"

    or check below folder : "C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe"


    Vishal Gajjar
    Wednesday, April 13, 2011 1:00 PM

All replies

  • you can remove the service using sc command:

     

    SC Command:

    DESCRIPTION: Deletes a service entry from the registry. If the service is running, or another process has an open handle to the service, the service is simply marked for deletion. USAGE: sc delete [service name]

     

    make sure you have un-installed SQLServer completed before deleting the service.

    you won't be able to get it back unless you reinstall.


    Vishal Gajjar
    Wednesday, April 13, 2011 10:35 AM
  • this command work for remove sql services form services.msc but when I reinstall Sql server 2005 ,It show that default instance is

    available and when I install named instance ,it show that Client component is allready installed and stop me to install client component ,event

    I am not able to open sql server management studio.

    Is there any solution for install default instance .and client component.


    Sunil Dahiya
    Wednesday, April 13, 2011 12:47 PM
  • Hi Sunil,

    Could you please post the error message you are receiving?

     

    The clients are not installed on per-instance basis. It is common for all instances, you need to install them only once.

     

    can you check if you already have client components installed?

    you should be able to open SQLServer Management by using Start > Run > "SqlWb.exe"

    or check below folder : "C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe"


    Vishal Gajjar
    Wednesday, April 13, 2011 1:00 PM
  • You may want to follow these instructions to remove the instance and all references to it completely.

     

    http://support.microsoft.com/kb/909967

    http://msdn.microsoft.com/en-us/library/aa337087(SQL.90).aspx


    looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
    Wednesday, April 13, 2011 1:09 PM