You receive a "Cannot connect to the configuration database" error message when you connect to your Windows SharePoint Services Web site (823287)
The information in this article applies to:
- Microsoft Office SharePoint Portal Server 2003
- Microsoft Windows SharePoint Services
SYMPTOMSWhen you try to view your Microsoft Windows SharePoint
Services Web site, you receive the following error message: Cannot connect to the configuration
database. CAUSEThis behavior occurs if one of the following conditions is
true:
- The SQL database is not running.
-or- - Internet Information Services (IIS) is configured to run in
IIS 5.0 isolation mode.
-or- - The account that is used by application pool does not have
the required permissions to the SQL Server database.
RESOLUTIONUse one of the following methods to resolve this behavior. Method 1: Verify That the SQL Database Is Running- Click Start, point to
Programs, point to Administrative Tools, and
then click Services.
- In the list of services, locate the
MSSQLSERVER service. This service may also be listed as
MSSQL$SHAREPOINT.
- Note the value of the Status column. If
the Status column lists Started, the database
server is running. If the Status column is empty, the database
server is not running. To start the database server, follow these steps:
- Right-click the MSSQLSERVER service,
and then click Start.
Method 2: Verify That IIS Is Not Running in IIS 5.0 Isolation Mode- Click Start, point to
Programs, point to Administrative Tools, and
then click Internet Information Services (IIS)
Manager.
- In the left pane, right-click your server name, and then
expand the local computer.
- Right click Web Sites, and then click Properties.
- Click the Service tab.
- Click to clear the Run WWW service in IIS 5.0
isolation mode check box.
- Click OK
- To start the WWW service, click
Yes.
Method 3: Make Sure That the Account That Is Used By the Application Pool Is the Account That Has the Required Permissions to the SQL Server Database. First, you must first determine the application pool identity.
To do this, follow these steps:
- Click Start, point to
Programs, point to Administrative Tools, and
then click Internet Information Services (IIS)
Manager.
- Double-click the Web Sites
folder.
- Right-click the virtual server that is running Windows
SharePoint Services, and then click Properties.
- Click Home Directory.
- Note the information that is in the Application
name box (this is the application pool name), and then click
Cancel.
- In the left pane, right-click Application
Pools, and then click Properties.
- Click the Identity tab.
- Note the information that is in the Application
pool identitypane, and then click Cancel.
Next, you must verify that this account has the required
permission the SQL Server database. To do this, follow these steps:
- Click Start, point to
Programs, point to Microsoft SQL Server, and
then click Enterprise Manager.
- In the left pane, double-click Microsoft SQL
Servers, and then double-click your SQL server group.
- Double-click your server.
- Double-click Security.
- In the left pane, click Logins.
- In the right pane, double-click the user who you noted step
8 of the previous procedure.
- In the SQL Server Login Properties dialog
box, click Server Roles.
- Click to select both the Security
Administrators and the Database Creators check boxes,
and then click Database Access.
- Under the Permit column, click to select
the Windows SharePoint Services database.
- Click OK.
Modification Type: | Minor | Last Reviewed: | 7/27/2006 |
---|
Keywords: | kbDatabase kbWebServices kbtshoot kberrmsg kbprb KB823287 kbAudITPRO |
---|
|