You receive a "Database access failed for this server" error message when you browse your SharePoint Team Services Web site (891988)


The information in this article applies to:

  • SharePoint Team Services from Microsoft

SYMPTOMS

When you browse your SharePoint Team Services from Microsoft Web site, you receive the following error message:
Database access failed for this server. This may be temporary due to maintenance reasons, or the server may be too busy to respond. Please try again later.

CAUSE

This issue may occur if something prevents SharePoint Team Services from connecting to the database in Microsoft SQL Server or in SQL Server Desktop Engine (also known as MSDE 2000). For example, this issue may occur if the following conditions are true:
  • You restored the database from a backup.
  • The connection to the database was interrupted during the restore operation.

RESOLUTION

To resolve this issue, use the Owsadm.exe command-line tool to set the value of the DatabaseAccess property for the virtual server to "enabled" (without the quotation marks). To do this, follow these steps:
  1. Click Start, click Run, type cmd in the Open box, and then click OK.
  2. At the command prompt, switch to the Drive:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\50\Bin folder.
  3. Type the following line at the command prompt, and then press ENTER:

    Owsadm -o setproperty -pn databaseaccess -pv enabled -p /lm/w3svc/Number

    Note Number is the number that indicates the instance of the virtual server. For example, the instance of the first virtual server on the server is represented as "/lm/w3svc/1" (without the quotation marks).
  4. Type exit, and then press ENTER to close the command prompt.

MORE INFORMATION

For additional information about how to use the Owsadm.exe command-line tool, click the following article number to view the article in the Microsoft Knowledge Base:

272945 SharePoint command-line utility (Owsadm.exe)

For more information about to configure and administer SharePoint Team Services, see the SharePoint Team Services product documentation. To view the SharePoint Team Services product documentation, visit the following Microsoft Web site:

http://www.microsoft.com/resources/documentation/STS/2001/all/proddocs/en-us/default.mspx

Modification Type:MajorLast Reviewed:1/4/2005
Keywords:kbConfig kberrmsg kbtshoot kbprb KB891988 kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.