Secure Store SQL exception - Event 7551 (SharePoint Server 2010)

  • Article

 

Applies to: SharePoint Server 2010, SharePoint Foundation 2010

Alert Name:   Secure Store SQL exception

Event ID:   7551

Summary:   The Secure Store service application connects to the credential database for reading or writing credentials. This event is logged when the service application fails to connect to the database. The SQL Server exceptions are not logged immediately; the system tries to connect the service application to the database three times before it logs the errors. This is because some unexpected, but temporary, system failures can also cause the SQL Server exceptions.

Symptoms:   The following event appears in the event log: Event ID: 7551 Description: The Secure Store service application %name% errored out because of a database exception.

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

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

  • The Secure Store service application database connection information is incorrect.

  • The Secure Store service application metadata database was not provisioned correctly.

Resolution:   Verify that the Secure Store service application server is available

  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, under System Settings, click Manage services on server.

  3. On the Services on Server page, under Services, if the Secure Store service is not started, click Start.

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

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

  6. On the Service Applications page, ensure that the Secure Store service application is started, and then click Secure Store.

  7. On the Secure Store Service Application page, ensure that at least one target application appears in the list.

  8. If the Secure Store service application is not started, do the following:

    1. On the Service Applications page, select the Secure Store service application name, and then click Properties on the ribbon.

    2. In the Edit Properties dialog box, in the Database section, ensure that the authentication method used is correct and that the account (if listed) has read and write permissions to the database.

    3. In the Application Pool section, ensure that the application pool account (if listed) has sufficient permissions to run the application pool.

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

  10. On Service Applications page, select the Secure Store Service Application.

  11. On the ribbon, click Properties.

  12. Verify that the database server name and other connection properties are correct.