delete a named instance - how?

SQL Server 2005

I have an empty named instance on my SQL Server 2005 server. Not
the default instance, but a secondary named instance. I would like
to completely delete this named instance w/o touching the default
instance.

How do I do this?

I see various things when I google, some of which say that I have to
uninstall and reinstall SQL Server 2005! Is this really necessary?
Some say that I have to do registry surgery?

As an aside, as part of this, I tried to get to
http://support.microsoft.com/kb/290991,
and I get 404 not found. I have seen this with other MS KB URL's as
well. Has the URL protocol/format changed for MS KB?

Any help appreciated.

A freshly minted SQL Server DBA...

aj
.

Relevant Pages

  • change a named instance to default instance
    ... Produced By Microsoft MimeOLE V6.00.2800.1441 ... even though there is only one SQL Server ... | Is there anyway I can make my named instance behave like the default? ... Configure an Alias by Using TCP/IP Sockets ...
    (microsoft.public.sqlserver.connect)
  • Re: What is the server name for a standalone XP SP2?
    ... How should one uninstall a Named instance in a clean fashion? ... Configuration Manager of SQL Server 2005. ... I checked the menus in the Configuration Manager and connot figure out how ... You can uninstall Named and Default instances if you do not need them. ...
    (microsoft.public.sqlserver.setup)
  • Re: x64 2003 Cluster - SQL2000 named instance fail
    ... one the settings are not detected by the setup. ... > in the cluster log you will notice the a connection to the SQL Server ... > named instance cannot be established. ... >> Microsoft highly recommends that users with Internet access update their ...
    (microsoft.public.sqlserver.clustering)
  • RE: Cluster Configurations
    ... MCTS: SQL Server 2005 ... "Mohit K. Gupta" wrote: ... Named Instance -> Failover to Node 4 ...
    (microsoft.public.sqlserver.clustering)
  • Re: Cannot connect to second cluster node w/instance name
    ... Is the SQL Server Browser Service running to provide the tcp port number for the named instance? ... When I attempt to connect to node2 remotely I get an error basically stating "An error has occurred while establishing a connection to the server. ... When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. ...
    (microsoft.public.sqlserver.connect)