Visio configuration database not found - Event 8040 (SharePoint Server 2010)

Applies to: SharePoint Server 2010

Alert Name:   Visio configuration database not found

Event ID:   8040

Summary:   Visio Services in Microsoft SharePoint Server 2010 stores its application settings in the configuration-a12-n database. Access to this database is critical for the service to function.

Symptoms:   One or more of the following symptoms might appear:

• Visio Services might fail to render diagrams.

• This event appears in the event log: Event ID: 8040 Description: Can't find configuration manager.

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

• The configuration database is inaccessible.

• The configuration database is responding slowly due to heavy network activity or load on the Microsoft SQL Server computer.

Resolution:   Verify the status of the SQL Server configuration database

1. On the SharePoint Central Administration Web site, in the System Settings section in the reading pane, click Manage Servers in this farm.

2. In the Farm Information section, note the Configuration database server and the name and the version of the configuration database.

3. Start SQL Server Management Studio and connect to the configuration database server.

4. If the configuration database does not exist, run the SharePoint Products and Technologies Configuration Wizard.

Resolution:   Verify the SQL Server network connection

1. On the Central Administration page, in the System Settings section in the reading pane, click Manage Servers in this farm.

2. In the Farm Information section, note the Configuration database server and the name and the version of the configuration database information.

3. Open a Command Prompt window and type ping <serverAddress> to confirm the server connection.

4. Failure to contact the server indicates a problem with the network connection or another problem that prevents a response from the server.

5. Log on to the server computer and troubleshoot the issue.