Knowledge Base

The VMware Knowledge Base provides support solutions, error messages and troubleshooting guides

Search the VMware Knowledge Base (KB)

View by Article ID

Performance Overview plug-in is disabled when VirtualCenter Server is connected to remote SQL Server

Details

The Performance Overview plug-in is disabled if VirtualCenter Server is connected to remote SQL Server listening on a non-standard SQL port. The standard SQL port is 1433.

Solution

To start the Performance chart application:

Open the Performance chart database configuration file. If you have installed VirtualCenter in the default directory, the configuration file is available at C:\Program Files\VMware\Infrastructure\VirtualCenter Server\tomcat\conf\Catalina\localhost\statsreport.xml
Navigate to the location in the XML file after these entries:

<Resource auth="Container"
name="jdbc/StatsDS"
Change the following entry to suit your environment:
url="jdbc:sqlserver://<serverName>:<port>;instanceName=<ServerName>;databaseName=<databaseName>;integratedSecurity=true"
Notes:
- By default, the JDBC connection bridges to the VirtualCenter server is configured with ODBC connection. In this case, you need not specify the username or password.
- If no instance name is available, the instance name is the same as the server name. You can also use MSSQLSERVER as the instance name.
Restart the VirtualCenter Management Webservices service.

Keywords

Performance overview plugin, sql port

Request a Product Feature

To request a new product feature or to provide feedback on a VMware product, please visit the Request a Product Feature page.

Feedback

1 2 3 4 5

1 2 3 4 5

Actions

Bookmark Document

Did this article help you?
This article resolved my issue. This article did not resolve my issue. This article helped but additional information was required to resolve my issue.
What can we do to improve this information? (4000 or fewer characters)