We are trying to run the load DWH job (not full load) and we get an error: "error occurred while trying to connect to the database"
"Login failed for user 'ppm_dwh'."
However, we are certain that the password for connecting to the database is correct.
Confirmed it in SQL Studio, the NSA and properties.xml
We haven't changed the password and it has been working fine but not today unfortunately.
Can anyone please assist? Thanks.