When you use a Web browser to try to access a SharePoint
team Web site, you receive the following error message:
SQL Server Error
The SQL Server might not be started.
If this problem
persists, please contact your administrator.
Troubleshoot issues with
Microsoft SharePoint.
The SQL Server user account password was changed but was
not updated in the registry.
-or-
The SQL database may have
Restrict Access turned on. Restrict Access may cause contention when accessing
resources in the SQL database. This in turn can cause the error message in the
"Symptom" section to be generated.
Warning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall your operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.
To resolve this problem, reset the SQL Server user account
password (default = SA) by using SQL Enterprise Manager. To do this, follow
these steps:
- Click Start, point to
Programs, and then click SQL Server.
Click Enterprise Manager. - Expand the Microsoft SQL Server
selection.
- Expand the SQL Server Group
selection.
- Expand the Machine Name
selection.
- Expand the Security folder.
- Double-click Logins.
- In the right pane, right-click the user name (for example,
SA).
- Click Properties.
- Reset the password.
Verify that the password matches the registry
key.
WARNING: If you use Registry Editor incorrectly, you may cause serious
problems that may require you to reinstall your operating system. Microsoft
cannot guarantee that you can solve problems that result from using Registry
Editor incorrectly. Use Registry Editor at your own risk.
- Click Start, click Run,
and then type Regedit in the Open
box.
- Expand the following key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\Secure\/LM/W3SVC/#:] # = Virtual server #
- Verify that the databasePassword is the same as the
password that you reset earlier in this procedure. If it is not, double-click
databasePassword, and then type the same password that you
typed in the SQL Enterprise Manager.
Note Also verify that the DSN is pointing to the correct SQL
database.
To resolve the database contention problem, you have to clear
the
Restrict Access setting. To do this, follow these steps:
- Start SQL Enterprise Manager.
- Locate the Content Database that you used for your
particular Team Site.
- Right-click the database, and then click
Properties.
- Click the Options tab, click
Restrict Access to clear the setting, and then click
OK.
After you complete these steps, the Team Site should be able to successfully connect to this database and perform operations as directed by
the Web site.
This behavior applies to both SQL Server 7.0 and SQL Server
2000 installed locally or remotely.