Error when connecting with PASS GUI client: "Failed to connect to the Performance Repository"
Message: Failed to connect to the Performance Repository
Connection string: REPOSITORY_SERVER\INSTANCE_NAME
Database Name: Quest_Performance_Repository
Component Class: TSCSourceConnection
Most likely it is that the PA GUI client is trying first to use the user than PA is configured with, and there is no trust relationship between the PA GUI client machine, and the repository, so it falls back to whatever user that you are logged into the PA GUI client machine and tries that. If that user does not have access to the database, the repository connection fails with the above error message.
Typically there are three ways to resolve this problem:
1) Grant repository DB access to the user that you are logged into the PA GUI client machine.
2) Re-configure the repository database for each instance to use SQL authentication instead of Windows authentication.
3) Log into the PA GUI client machine as the user that the repository is configured with.
The most preferable option is number 2, that way the GUI will work on any machine and it doesn't matter what user is logged in.