Self-Solve Knowledge Search

Minimize Maximize
Database Connection Error: failed Open Connection: Login failed for user 'DOMAIN...
Title :
Database Connection Error: failed Open Connection: Login failed for user 'DOMAIN\IUSR_METRO'
Document ID :
KM01732378
Product - Version:
performance center ;
OS :
Updated :
Thu Jul 09 22:30:41 GMT 2015
Summary :
Error message during system health check: Database Connection Error: failed Open Connection: Login failed for user 'DOMAIN\IUSR_METRO' when we are using Windows Authentication
Problem
Running the system health check we got the following error message from PC server database connection check:
"Database Connection Error: failed Open Connection: Login failed for user 'DOMAIN\IUSR_METRO'".
Cause
When we install the database and we use Windows authentication instead of SQL authentication.
Fix

In order to resolved this issue

1. Add the IUSR_METRO into the Database--> Logins
2. Assign the db_owner permissions