Microsoft KB Archive/831105

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

Article ID: 831105

Article Last Modified on 9/26/2007

-

APPLIES TO


 * Microsoft Windows SharePoint Services

-





SYMPTOMS
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:

Unable to connect to database. Check database connection information and make sure the database server is running.



CAUSE
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.



RESOLUTION
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:  Click Start, and then click Run. In the Open box, type cmd, and then click OK. At the command prompt, type the following line, and then press ENTER:

net start mssql$sharepoint

 Type exit, and then press ENTER to exit Command Prompt. </li> Restart the server.</li></ul>

<div class="moreinformation_section">

MORE INFORMATION
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:

http://www.microsoft.com/downloads/details.aspx?FamilyID=a637eff6-8224-4b19-a6a4-3e33fa13d230&amp;displaylang=en

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

http://technet.microsoft.com/windowsserver/sharepoint/default.aspx

Additional query words: wss

Keywords: kbprb kbdatabase kbupgrade kbwebservices kbtshoot kberrmsg kbnofix KB831105

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.