This behavior occurs if one of the following conditions is true:
- The SQL database is not running.
- Internet Information Services (IIS) is configured to run in IIS 5.0 isolation mode.
- The account that is used by application pool does not have the required permissions to the SQL Server database.
- Network connectivity has been lost between the Windows SharePoint Services server and the Microsoft SQL Server server.
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, 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 2.0, 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.
Method 4: Make sure that you have network connectivity and correct name resolution between the servers
To do this, follow these steps:
- Verify that the Windows SharePoint Services server is using the correct IP address for the SQL server. To do this, run the ping command on the Windows SharePoint Services server.
- Verify that the Windows SharePoint Services server is obtaining the correct IP address for the SQL server from DNS. To do this, run the nslookup command from the Windows SharePoint Services server.
- Make sure that there are no incorrect entries for the SQL server. To do this, examine the Hosts file on the Windows SharePoint Services server. This file is in the following location:%systemroot%\system32\drivers\etc\Hosts
- On the Windows SharePoint Services server, look for SQL client aliases. To do this, follow these steps:
- Click Start, click Run, and then type cliconfg in the Open box.
- Click the Alias tab.
By default, there are no SQL client aliases. If you have any aliases for the SQL server, verify that they are correct, or remove them.