Highlighted
Member.
273 views

ALM DataBase Connection SQL Server

when running the system health it shows this error on the server "Database Connection Error: failed OpenConnection: failed OpenConnection: Error related to the network or specific to the instance while establishing a connection with the SQL Server. The server or the server could not be found was not accessible. Verify that the instance name is correct and that SQL Server is configured to support remote connections. (provider: TCP Provider, error: 0 - The remote computer rejected the network connection.) "when checking, the base Data allows remote connection, being tested by connecting from the same server of the Performance Center. Both servers can be connected by PING to the ip and to the name of each machine.
How can I solve this problem ?
thank 

0 Likes
1 Reply
Highlighted
Micro Focus Frequent Contributor
Micro Focus Frequent Contributor

Re: ALM DataBase Connection SQL Server

Hi Ariel.

Which ALM/PC version are you using?

Also, please check the below recommendations.

  • Move the Lab Project and user project DB schemas associated with ALM platform from a named SQL
  • Server instance to a default SQL Server instance running on the default port (TCP port 1433).
  • If using a new ALM/PC setup, reconfigure ALM and PC to the new DB server with default SQL instance (no named instance).
  • Configure the SQL named instance dynamic port to match the port number used in the PCS -> database connection string.

If the error is still present, please open a discussion on the ALM forum, since this is related to ALM connection to DB.

Regards

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.