We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

Error while connecting to sql server instance

Comments

2 comments

  • Avatar
    Adrian Williams

    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

     

    0
    Comment actions Permalink
  • Avatar
    Adrian Williams

    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
    0
    Comment actions Permalink

Please sign in to leave a comment.