Data360 Analyze

 View Only

  • 1.  Error while connecting to sql server instance

    Posted 10-27-2020 14:08

    I am getting the following error when trying to connect to sql server:

    Unable to connect to "jdbc:jtds:sqlserver://USIDCVSQLC0501.CORP.GLOBAL.LEVEL3.COM;databaseName=STORMrt;domain=level3;useNTLMv2=true". Exception: "Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.".

    DBUser and DBPassword are filled out on node properties.

    Any help would be appreciated on next steps.



  • 2.  RE: Error while connecting to sql server instance

    Employee
    Posted 10-28-2020 03:17

    Looking online there are a number of conflicting suggestions, so your mileage may vary with the following suggestions:

    - Check the user and the Database are on the same domain

    - When entering the username do not include the domain/ element, just use the actual user name

    - Get your DBA to check the SQL Server logs for login failure information; the error state may provide detail on the actual reason for the failure. Also confirm that the Database is configured to accept connections from that domain

    - Try setting the domain to be corp.global.level3.com

     



  • 3.  RE: Error while connecting to sql server instance

    Employee
    Posted 03-30-2021 08:58

    Update: We recommend using the default microsoft driver for SQL Server instead of the jTDS driver. Starting from Data360 Analyze release 3.6.8 the Microsoft driver can be used with Windows Authentication. The DbURL should be similar to the following format:

    jdbc:sqlserver://<hostname>:<port>;authenticationScheme=NTLM;domain=INFOGIX;integratedSecurity=true