Business Data Connectivity Service - SQL exception - Event 8086 (SharePoint 2010 Products)

 

Applies to: SharePoint Server 2010

Alert Name:   Business Data Connectivity Service - SQL exception

Event ID:   8086

Summary:   The Business Data Connectivity service application connects to the metadata store to allow users to manage the metadata in the metadata store. This event is logged when the service application fails to connect to the database. The Business Data Connectivity metadata in the metadata store will not be accessible. This will impact importing and exporting application models or updating properties for any of the Business Data Connectivity objects by using the Business Data Connectivity Service Application Proxy page in the SharePoint Central Administration Web site.

Symptoms:   This event appears in the event log: Event ID: 8086 Description: The BDC service application %name% error occurred because of a database exception.

Cause:   One or the more of the following might be the cause:

  • The metadata database server is down or not accessible because of network issues.

  • The connection information for the Business Data Connectivity service application metadata database is incorrect.

  • The Business Data Connectivity service application metadata database was not provisioned correctly.

Resolution:   Verify the availability of the metadata database server

  1. Verify that the user account that is performing this procedure is a member of the Farm Administrators group.

  2. On the Central Administration Home page, click Application Management.

  3. On the Application Management page, in the Service Applications section, click Manage service applications.

  4. On the Service Applications page, select the Business Data Connectivity Service Application, and click Properties on the ribbon.

  5. Verify that the database server listed on the Properties page is available and can be connected to from SharePoint 2010 Products.

See Also

Other Resources

Resource Center: Operations and Manageability for SharePoint Server 2010
Resource Center: Operations and Manageability for SharePoint Foundation 2010