Microsoft KB Archive/292660

From BetaArchive Wiki
Knowledge Base


STS: Database Is Not Removed from Remote SQL Server Computer When You Remove SharePoint Team Services

Article ID: 292660

Article Last Modified on 8/6/2002



APPLIES TO

  • Microsoft SharePoint Team Services



This article was previously published under Q292660


SYMPTOMS

When you uninstall SharePoint Team Services from a Web server running Microsoft SQL Server, the SharePoint database is not removed from the remote SQL Server computer as expected.

CAUSE

This behavior can occur if all of the following conditions are true and occur in the given order:

  • You install SharePoint Team Services by using the /nd command-line switch. The switch indicates that the MSDE edition of SQL Server should not be installed, even though there is no SQL Server installation on the computer.


-and-

  • The SharePoint team Web site is extended, and a remote SQL Server installation (running on a second computer) is being used for storing data on and managing the SharePoint team Web site.


-and-

  • You perform a full uninstall of SharePoint Team Services.


WORKAROUND

To resolve this problem, manually delete the SharePoint database from the SQL Server computer. To do this, follow these steps:

  1. Start the Enterprise Manager. To do this, point to Programs on the Windows Start menu, point to Microsoft SQL Server, and then click Enterprise Manager.
  2. Expand Microsoft SQL Servers, expand SQL Server group, expand the server name, and then expand Databases.
  3. Right-click the SharePoint database, and then click Delete.
  4. In the Delete Database dialog box, click Yes.


STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.


Additional query words: FPSE

Keywords: kbbug kbnofix KB292660