Databases (Health model)
Applies To: Windows SharePoint Services 3.0
Windows SharePoint Services 3.0 uses SQL Server databases to store most of the content for the Web site and configuration settings. For example, all pages in the site, files in document libraries, files attached to lists, and information in lists are stored in the content database, and security and permission settings along with other configuration settings are stored in the configuration database in SQL Server.
Windows SharePoint Services 3.0 uses a service account to communicate with the database on behalf of a user request. This service account can be either a specific user name and password (domain name and password) or a predefined system account, such as Local System or Network Service. When a SQL Server database is created, a value for the maximum database size is set. Each database has a separate database size setting. Note that a Web application might be associated with one or many databases.
Events
| Event ID | Source | Message |
|---|---|---|
Windows SharePoint Services 3 |
SQL database login failed. Additional error information from SQL Server is included below. %1 |
|
Event ID 3355 (Windows SharePoint Services health model) (Windows SharePoint Services health model) |
Windows SharePoint Services 3 |
Cannot connect to SQL Server. %1 not found. Additional error information from SQL Server is included below. %2 |
Windows SharePoint Services 3 |
Specified SQL Server not found. Additional error information from SQL Server is included below. %1 |
|
Windows SharePoint Services 3 |
Incorrect Microsoft Data Access Component version. Windows SharePoint Services requires at least version 2.8.1022.0. |
|
Windows SharePoint Services 3 |
SQL Server version %1 or greater required. |
|
Windows SharePoint Services 3 |
Database full error on SQL Server instance '%1' in database '%2'. Additional error information from SQL Server is included below. %3 |
|
Windows SharePoint Services 3 |
Database '%1' on SQL Server instance '%2' is not empty and does not match current database schema. |
|
Windows SharePoint Services 3 |
SQL Database '%1' on SQL Server instance '%2' not found. Additional error information from SQL Server is included below. %3 |
|
Windows SharePoint Services 3 |
Cannot update database on SQL Server instance '%1'. Database is read/only. Additional error information from SQL Server is included below. %2 |
|
Windows SharePoint Services 3 |
The SQL Server collation on SQL Server instance '%1' is not supported. Windows SharePoint Services requires a Latin1 General dictionary order, case insensitive, accent sensitive, kana sensitive, and width sensitive collation (%2). |
|
Windows SharePoint Services 3 |
Insufficient SQL database permissions for user '%1' in database '%2' on SQL Server instance '%3'. Additional error information from SQL Server is included below. %4 |
|
Windows SharePoint Services 3 |
Unknown SQL Exception %1 occured. Additional error information from SQL Server is included below. %2 |
|
Windows SharePoint Services 3 |
Duplicate unique index on SQL Server instance '%1' in database '%2'. Additional error information from SQL Server is included below. %3 |
|
Windows SharePoint Services 3 |
Primary key violation on SQL Server instance '%1' in database '%2'. Additional error information from SQL Server is included below. %3 |
Related Management Information
Windows SharePoint Services 3.0 Web application (Health model)