Connection to host as user USER failed: ERROR: Wrong password for user
Usually you find this error when trying to connect to host, for example, you want to start/shutdown, or backup the database. It had confused me for a long time. Then I found an solution.
1. Provide the 'Log on as a batch job' privilege.
- Go to control panel/administrative tools
- click on "local security policy"
- click on "local policies"
- click on "user rights assignments"
- double click on "log on as a batch job"
- click on "add" and add the user(s) that you're going to use in database console.
- Go to the Preferences link in the database console page
- click on Preferred Credentials (link on the left menu)
- under "Target Type: Host" click on "set credentials"
- enter the OS user(s) for whom you have set "logon as a batch job" privilege
- click on "Test"
