4 Replies Latest reply on Jul 10, 2013 7:04 AM by Aswath Khan

    Error While Preview Data: Validate JDBC username and password in the default Teiid server

    Aswath Khan Newbie

      I'm using

           Teiid Designer 8.1.0 (Final)

           Teiid Server 8.1.0 (Jboss Dist Final)

           JBoss AS 7.1.1 (Final)

           Eclipse JEE Juno SR2 (Wiin32)

       

      I  could able to create the

           1. DB JDBC connection

           2. Start the Teiid Server using standalone-teiid.xml config file

           3. Create Source Model

           4. Define VDB

      But I'm encountring the following 3 problems, which I feel is related,

       

      1.  'Preview Data' - I get the following error,

       

                Validate JDBC username and password in the default Teiid server

       

      But I could able Test the Administration connection using the default username/pwd (admin/admin)

       

      I did not change any default user, so I'm using the same default username/pwd (user/user). But still I get this error.

       

       

      2. When I try the link  Test JDBC Connnection, I get the following error,

       

       

       

       

       

       

       

                "Unable to establish a jdbc connection to server "jdbc:teiid:ping@mm://localhost:31000"

      3. When I try to open a VDB using Database Development Perspective, I get the following error,

       

       

      I feel that all the above 3 errors are interrelated, fixing one will fix the other errors too. Please help, your help will be appreciated.

      Thanks,

      Aswath

       

       

       

                TEIID50072 The username "user" and/or password and/or payload token could not be authenticated by any membership domain.