Forum Discussion

sandy55432's avatar
sandy55432
Occasional Contributor
5 years ago
Solved

This driver is not configured for integrated authentication.

Getting error as : This driver is not configured for integrated authentication.      Everything is in place,  the sqljdbc42.jar in C:\Program Files\SmartBear\ReadyAPI-2.8.0\bin\ext path    ...
  • richie's avatar
    5 years ago

    Hi sandy55432

     

    You're talking about using an RDBMS's .jar file to support a db connection, right? If thata the case, you need to setup your db connection first.

    If thats the case theres a number of things you need to consider.

     

    1. the above mentioned error message can occur if you try to run a Java instance using a driver with the wrong 'bit type' (sorry - dont know the correct term here) .  That is, you need to ensure you have a Java instance relative to your machines bit type for want of a better phrase - if you're using 64bit ReadyAPI! - you need to ensure you have 64bit not32bit  version of Java installed - if you're using 32bit ReadyAPI! then you need 32bit Java installed - so have a look in your Program Files and Program Files (x86) directories - which one contains your ReadyAPI! instance then double check if the shortcut you are running ReadyAPI! from does point to the correct program files directory (64 or 32bit).  Next - open a command window - then at the prompt - execute 'java -version <RETURNKEY>' <--this will tell you what version of Java and whether it's 32 or 64bit.  I'd also just double check your Windows' 'Path' environment variable - you should have a pointer in your Path variable (which gets set when you install a JRE/JDK) to the JVM directory.


    2. Identify the RDBMS and version you need to connect to...e.g. MS SQLServer 2018.

    3. You need to determine which version of java runtime is required to connect via JDBC to your RDBMS, e.g. SQLServer 2018 supports jre8

    4. Find out which driver .jar file is required to connect to your RDBMS

    5. Install the correct jre and .jar file (e.g. MS SQLServer 2018 can use jre8 and so i installed JREv8.0 and picked up the mssql-jdbc-7.0.0.jer8.jar and stick it in ../bin/ext

    6. I then launched the JDBC preferences and configure your db connection


    N.b. i have always struggled to connect SQLServer using Windows Authentication or mixed mode....the only way i've ever got a connection was using SQL authentication.

    Anyway...im assuming this will start you of in the right direction

    Cheers

    Rich