Ingres Community Forums - View Single Post - Database connectivity problem from Talend/JasperSoft

notnull · 2009-06-15

Hi Lipika,

There are usually two reasons why you get that error:

The authentication mechanism set-up has not been completed or
The user connecting to the database is different to the user who owns the database.

You have not indicated what version or platform you are using.

On *nix take a look at http://docs.ingres.com/Ingres/9.2/Co...lnet.htm#o1204. You can check if authentication mechanism set-up has been completed by the existence of II_SHADOW_PWD in the Ingres symbol table.
On Windows ensure that the owner of the Ingres instance has to relevant rights enabled.

Check the owner of the database and the user that you are connecting with are both valid Ingres users. If you don't specify user and password credentials in the JDBC connection then the current user is assumed.

2009-06-15	#2 (permalink)
notnull Ingres Community Join Date: Mar 2007 Location: Orpington, Kent, UK Posts: 97	Hi Lipika, There are usually two reasons why you get that error: The authentication mechanism set-up has not been completed or The user connecting to the database is different to the user who owns the database. You have not indicated what version or platform you are using. On *nix take a look at http://docs.ingres.com/Ingres/9.2/Co...lnet.htm#o1204. You can check if authentication mechanism set-up has been completed by the existence of II_SHADOW_PWD in the Ingres symbol table. On Windows ensure that the owner of the Ingres instance has to relevant rights enabled. Check the owner of the database and the user that you are connecting with are both valid Ingres users. If you don't specify user and password credentials in the JDBC connection then the current user is assumed.