You receive an "Unable to connect to database" error message when you connect to a Windows SharePoint Services Web site after you upgrade WMSDE to SQL Server 2000

When you connect to a Microsoft Windows SharePoint Services site after you upgrade the instance of Microsoft SQL Server Desktop Engine (Windows) (WMSDE) on the server to Microsoft SQL Server 2000, you may receive the following error message:

This issue occurs if the MSSQL$SharePoint service is not started on the server. When you upgrade WMSDE to Microsoft SQL Server on a server that is running Windows SharePoint Services, the MSSQL$SharePoint service is stopped after the upgrade operation.

To resolve this issue, do one of the following as appropriate to your situation:

• Start the MSSQL$SharePoint service. To do so, follow these steps:
  1. Click Start, and then click Run.
  2. In the Open box, type cmd, and then click OK.
  3. At the command prompt, type the following line, and then press ENTER:
     net start mssql$sharepoint
  4. Type exit, and then press ENTER to exit Command Prompt.
• Restart the server.

When you upgrade WMSDE to Microsoft SQL Server on a server that is running Windows SharePoint Services, you must restart the MSSQL$SharePoint service after the upgrade operation is complete. To do so, either manually start the service or restart the server.

For additional information about how to install and manage Windows SharePoint Services, see the Microsoft Windows SharePoint Services 2.0 Administrator's Guide. To obtain the Microsoft Windows SharePoint Services 2.0 Administrator's Guide, visit the following Microsoft Web site:

For more information about Windows SharePoint Services, visit the following Microsoft Web site: