Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: How to connect SQL using Windows ID

  1. #1
    Join Date
    Mar 2017
    Posts
    1

    Post How to connect SQL using Windows ID

    <?xml version="1.0" encoding="UTF-8"?>
    <sharedobjects>
    <connection>
    <name>xxxx</name>
    <server>xxxxx</server>
    <type>MSSQL</type>
    <access>Native</access>
    <database>test</database>
    <port>4101</port>
    <username>EUROPE\testConnect</username>
    <password>********</password>
    <servername/>
    <data_tablespace/>
    <index_tablespace/>
    <attributes>
    <attribute><code>FORCE_IDENTIFIERS_TO_LOWERCASE</code><attribute>N</attribute></attribute>
    <attribute><code>FORCE_IDENTIFIERS_TO_UPPERCASE</code><attribute>N</attribute></attribute>
    <attribute><code>IS_CLUSTERED</code><attribute>N</attribute></attribute>
    <attribute><code>MSSQL_DOUBLE_DECIMAL_SEPARATOR</code><attribute>N</attribute></attribute>
    <attribute><code>PORT_NUMBER</code><attribute>4101</attribute></attribute>
    <attribute><code>PRESERVE_RESERVED_WORD_CASE</code><attribute>N</attribute></attribute>
    <attribute><code>QUOTE_ALL_FIELDS</code><attribute>N</attribute></attribute>
    <attribute><code>SUPPORTS_BOOLEAN_DATA_TYPE</code><attribute>Y</attribute></attribute>
    <attribute><code>SUPPORTS_TIMESTAMP_DATA_TYPE</code><attribute>N</attribute></attribute>
    <attribute><code>USE_POOLING</code><attribute>N</attribute></attribute>
    </attributes>
    </connection>
    </sharedobjects>


    tried using above xml to connect to SQL but from SQL Error log showing:
    Login failed for user 'EUROPE\pCMDB-AMSDC1SCCM-S'. Reason: Attempting to use an NT account name with SQL Server Authentication. [CLIENT: <named pipe>]




    It is still trying to connect using SQL Server Authentication. How to set it as NT account login ?
    Last edited by fazlin; 03-13-2017 at 06:48 AM.

Tags for this Thread

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.