New Ranks & Badges For The Community!
Notice something different? The ranks and associated badges have gone "Star Fleet". See what they all mean HERE
Highlighted
Absent Member.
Absent Member.
3731 views

Database Connection Error: failed OpenConnection for PC servers

Jump to solution

Database Connection Error: failed OpenConnection: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.

 

When i do a "Check System" in labmanagement under the tab Performance Center i get the above error for both our PC servers.

 

In ALM, when i try to open an uploaded vuGen script i get the following error:

 

Problem encoutered when application tried to connect to data base: failed OpenConnection: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.

 

Does anyone know how to fix?

0 Likes
1 Solution

Accepted Solutions
Highlighted
Commodore
Commodore

Hi,

 

Can you confirm the version you are using?

I have seen such errors in the past when you configure your database to use Windows Authentication but you left the PC System user to its default (IUSR_METRO).

 

Changing the PC system identity to the user you are using to access the databse for Windows Authentication or to a domain user that has the same right on the databases will allow you to fix the issue.

 

Please refer to the following guides:

Performance Center Installation Guide - http://support.openview.hp.com/selfsolve/document/KM00425855

Section "Enabling MS-SQL Windows Authentication" page 137

 

Performance Center Administrator Guide - http://support.openview.hp.com/selfsolve/document/KM00425856

Section "How to Change the System User" page 458

 

Let me know if any of the above information is unclear

Thanks,

./Sebastien

View solution in original post

0 Likes
3 Replies
Highlighted
Commodore
Commodore

Hi,

 

Can you confirm the version you are using?

I have seen such errors in the past when you configure your database to use Windows Authentication but you left the PC System user to its default (IUSR_METRO).

 

Changing the PC system identity to the user you are using to access the databse for Windows Authentication or to a domain user that has the same right on the databases will allow you to fix the issue.

 

Please refer to the following guides:

Performance Center Installation Guide - http://support.openview.hp.com/selfsolve/document/KM00425855

Section "Enabling MS-SQL Windows Authentication" page 137

 

Performance Center Administrator Guide - http://support.openview.hp.com/selfsolve/document/KM00425856

Section "How to Change the System User" page 458

 

Let me know if any of the above information is unclear

Thanks,

./Sebastien

View solution in original post

0 Likes
Highlighted
Absent Member.
Absent Member.

That solved this problem for us.

We are working with ALM PC 11.50 on Windows 2008 sp2 servers.

0 Likes
Highlighted
Cadet 2nd Class Cadet 2nd Class
Cadet 2nd Class

When this problem occurred in our environment, we were using ALM PC 11.52  and transitioning to a new standalone database server, SQL Server 2008 R2 SP2 on a Windows Server 2012 R2 machine.  It turned out that the local account IUSR_METRO on the new database server had been assigned an incorrect password when the account was added to the server.   Changing the password for this account on the database server to match the password already assigned to this account on the other Performance Center machines resolved the problem. 

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.