Caused by: java.sql.SQLException: Login failed for user
i have installed OO 10.20 and did a patch upgrade to 10.22.0001 and this was done using SQL server account .Now it has to configured to work with windows authentication . So i'm following Database guide 10.2x under that " Configuring HP OO to work with Windows Authentication " section and did the changes accordingly ,but after the doing the changes OO is not coming up .It's giving 404 error in the browser.
when i went through the logs i could see "Caused by: java.sql.SQLException: Login failed for user " .So is that the login issue of the Windows credentials ? I just wanted to double confirm before asking the customer to look into it and i have also encrypted the password to key that in the database,properties file
The error seems related to the changes that have been performed on the authentication part.
It needs to be investigated as it might be:
a. something in the database.properties guide that has not been placed properly.
Note that the jdbc.url parameter is broken into several lines using trailing backslash characters.
b. the target server not accepting Windows authentication yet.
Hi Andrei ,
I had to add windows credentials in the HP OO service Log On section after that it worked, I got to know about this from my colleague and also this part was missed out in the Database guide that i was referring to . So the issue is solved and configuration is working now . 🙂