Microsoft KB Archive/891988

= You receive a &quot;Database access failed for this server&quot; error message when you browse your SharePoint Team Services Web site =

Article ID: 891988

Article Last Modified on 1/4/2005

-

APPLIES TO


 * Microsoft SharePoint Team Services

-





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 &quot;enabled&quot; (without the quotation marks). To do this, follow these steps:  Click Start, click Run, type cmd in the Open box, and then click OK. At the command prompt, switch to the :\Program Files\Common Files\Microsoft Shared\Web Server Extensions\50\Bin folder. Type the following line at the command prompt, and then press ENTER:

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

Note  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 &quot;/lm/w3svc/1&quot; (without the quotation marks). 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

Additional query words: sts

Keywords: kberrmsg kbtshoot kbprb kbconfig KB891988

-

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

© Microsoft Corporation. All rights reserved.