Resolve an HPC reporting database connection problem
Artikel
Resolve a high-performance computing (HPC) reporting database connection problem in the Microsoft HPC Cluster Manager.
Symptoms
In the HPC Cluster Manager, after you select another reporting database in the Charts and Reports pane, the Cluster Manager can no longer connect to the database, and you receive an error message that resembles the following text:
The HPC Cluster Manager cannot connect to the reporting database. Please check connection string 'Data Source=<data-source-name>;Initial Catalog=TCHPCReporting;Integrated Security=True;' and make sure you have access.
Cannot open database 'TCHPCReporting' requested by the login. The login failed.
Login failed for user <user-name>.
For example, this symptom might occur if you switch between the Cluster Utilization and Node Availability reports, or to any other HPC Pack built-in report or custom report.
Cause
You're using Microsoft HPC Pack 2016 Update 1. In this version of HPC Pack, the connection problem that is described in the "Symptoms" section is a known issue.
Solution 2: Use HPC Pack 2016 Update 3 and install extra fixes
To move to HPC Pack 2016 Update 3 and install some extra required fixes, follow these steps:
In the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\HPC\Security\ReportingDbConnectionString registry subkey, make sure that the connectionstring entry is configured correctly.
If you don't want to upgrade your installed version of HPC Pack, you can run the following SQL script manually to fix the database connection string. In the script, replace the placeholder with the exact connection string for the reporting database. To find that connection string, locate the connectionstring entry value in the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\HPC\Security\ReportingDbConnectionString registry subkey.
If the error still occurs after you run the script, restart the HPC management service, and then try again to select that reporting database in HPC Cluster Manager.
Azure HPC is a purpose-built cloud capability for HPC & AI workload, using leading-edge processors and HPC-class InfiniBand interconnect, to deliver the best application performance, scalability, and value. Azure HPC enables users to unlock innovation, productivity, and business agility, through a highly available range of HPC & AI technologies that can be dynamically allocated as your business and technical needs change. This learning path is a series of modules that help you get started on Azure HPC - you
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.