Thursday, March 26, 2015

Unknown SQL exceptions - Event 5586

Unknown SQL exceptions - Event 5586

Alert Name:   Unknown SQL exceptions

Event ID:   5586

Summary:   Microsoft SharePoint Foundation uses Microsoft SQL Server 2008 databases to store configuration settings and most of the content for the Web site. 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 2008.
Microsoft SharePoint Foundation 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 or 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.

Symptoms:   The following symptom might appear:

·         This event appears in the event log: Event ID: 5586 Description: Database full error on SQL Server instance <instance name> in database <database name>. Additional error information from SQL Server is included below. <SQL error message>.

Cause: The issue is because of many reasons, below are some of the reasons
1.    Insufficient SQL Server database permissions
2.    SQL Server database is full
3.    Incorrect MDAC version
4.    SQL Server database not found
5.    Incorrect version of SQL Server
6.    SQL Server collation is not supported
7.    Database is read-only

Solution: The issue could be of many reasons so it has many different solutions that should implement to resolve the issue. One of the solution would be your saver.
Please check the link below from MS to get the solutions.


I hope the above information will help you to resolve the issue, in case of any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.