Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Error connecting to database MS SQL Server 2005

  1. #1
    Join Date
    Sep 2011
    Posts
    2

    Post Error connecting to database MS SQL Server 2005

    Hi everybody,

    I'm trying to connect to MS SQL Server 2005 running in DEVOTEAM-SERVIC server.To access to the server i need to use "Remote Desktop Connection" and provide the IP adresse.

    when i try to connect to DB using these login information:

    - Host name:@IP
    - Database name:PENTAHO
    - Port number:1433
    - User Name: Administrateur

    I mentionned that i'm using pdi-ce-3.2.0.

    i get this message error:


    Error connecting to database: (using class net.sourceforge.jtds.jdbc.Driver)
    Échec de l'ouverture de session de l'utilisateur 'Administrateur'. L'utilisateur n'est pas associé à une connexion SQL Server approuvée.




    org.pentaho.di.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database


    Error connecting to database: (using class net.sourceforge.jtds.jdbc.Driver)
    Échec de l'ouverture de session de l'utilisateur 'Administrateur'. L'utilisateur n'est pas associé à une connexion SQL Server approuvée.


    Could please help me to identify the root cause of this problem and how to resolve it.


    Looking forward for your feed back


    Meryem

  2. #2
    Join Date
    Mar 2011
    Posts
    257

    Default

    i think the error is quite clear.
    user administrateur is not allowed to conenct to the database
    are you sure Administrateur is a database user ?

    greetz,
    Hans

  3. #3
    Join Date
    Sep 2011
    Posts
    2

    Default

    Hi,
    Fisrt of all, thank you for your feed back,

    Regarding your question, yes very sure.

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.