Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: Admin unable to log into Spoon

  1. #1
    Join Date
    Sep 2005
    Posts
    1,403

    Default Admin unable to log into Spoon

    Hi Matt,


    Downloaded latest build of Kettle and can't seem to login under the admin id under Windows 2000. Message I receive is "Sorry you don't have permissions to run Spoon". I can see the repository has been built successfully in SQL Server and that the guest and admin ID's are there in the R_USER table.



    Any idea what I might be doing wrong?



    Thanks



    P.S. Connection is via ODBC to MS Sql Server 2005.






    Thanks

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default RE: Admin unable to log into Spoon

    Hi Anonymous,

    To be honest, I never really tried to have a repository under Yukon.
    The reason for this is the lack of software. I tried one of the first versions of Express Edition but couldn't get it to work on my Windows XP. Maybe I need to try again.

    You did use admin as password, right?

    Cheers,

    Matt

  3. #3
    Join Date
    Nov 1999
    Posts
    9,729

    Default RE: Admin unable to log into Spoon

    Oh, and it's always faster to go native.
    ODBC is ... well ODBC.

    Matt

  4. #4
    Join Date
    Mar 2007
    Posts
    3

    Default Same problem with sql server 2000

    user accts are in R_USER, but I get error msg - "Sorry you don't have permissions to run Spoonand Chef". This msg is returned when leave admin password blank. When I put in "admin" as password, I get different error msg - "Incorrect Username or password".


    Am using ODBC. I can't get native connection to see repository in any fashion. I have tried the "options" tab using "instance" and "local" as value"

    Help

    Thanks

    Bill Whittaker 240-298-7606

  5. #5
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Bill, please check out the SQL Server chapter in the 2.5.0 Spoon documentation.
    It describes how to configure the JDBC driver properly.

    We use large text/clob fields to store information in the repository and the ODBC drivers don't always handle this properly.

    HTH,

    Matt

  6. #6
    Join Date
    Jul 2009
    Posts
    2

    Default SQL Server 2005

    I am getting the exact same response as bwhittaker below - Pentaho Data Integration v3.1.2 , SQL Server 2005.

    I have successfully implemented the product - all the tables are created in the target MS SQL database - but cannot login. If I try Admin (with no password) it returns 'no permissions', and if I enter the password (I tried the default), it returns 'incorrect username or password'.

    Am I missing something?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.