makila
Occasional Contributor
Joined 4 years ago
User Profile
User Widgets
Contributions
Re: Error getting response; null when trying to connect to an azure cloud database
There is currently no solution. I checked the logs in soapUI and it says: soapUI Error [Interactive prompts not supported for now]. Which means connecting to a Azure SQL database with MFA (MultiFactor Authentication) is currently not support by soapUI so it is "normal" it doesnt work.26Views0likes0CommentsError getting response; null when trying to connect to an azure cloud database
I have some issue trying to connect to a SQL database located in an azure cloud environment. We have a database in the azure cloud that uses activedirectorydefault as authentication method. I logged on to my devbox and tried to connect to it use the FREE version of soapUI. The steps I took: - Add a JDBC request to the soapUI project * Driver = com.microsoft.sqlserver.jdbc.SQLServerDriver * Connectionstring = jdbc:sqlserver://xxx.database.windows.net:1433;Authentication=ActiveDirectoryDefault; Database=xxx;encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30; - Add below .jar Java files to support azure cloud SQL database connections into the /lib folder of soapUI C:\Users\(Username)\AppData\Local\Programs\SmartBear\SoapUI-5.7.2\lib mssql-jdbc-12.8.1.jre8.jar + msal4j-1.17.2.jar And I now indeed manage to connect to the database (it makes a valid connection) but I still recieve an error in the logs "Error getting response; null" I originally had the same issue connecting to a database "outside the azure environment" when the jar file used to be sqljdbc42.jar (instead of mssql-jdbc-12.8.1.jre8.jar) I had to add some additional files in the lib folder that I have gotten from someone from smartbear at the time and that fixed the issue. Without these extra jar files it also DID not work. Those files were all in total six jaxb-x and jide jar files) However the sqljdbc42.jar and those additional jar files are outdated and those do not support ActiveDirectory type of authentication. So I had to update it to the newest version mssql-jdbc-12.8.1.jre8.jar and also add the jar file msal4j-1.17.2.jar to communicate with the cloud to be able to connect. All connection errors now disappeared BUT now I have an error with the response that is returned which is exactly that same old issue again I had years earlier "Error getting response; null". I assume some extra additional jar files have to be added AGAIN to the lib folder because for some reason soapUI cannot understand the response from azure now. So my question is. Where can I find those files? Or is azure cloud just not supported through the free version of readyAPI? And then I come to my second question: If I Upgrade to readyAPI (PAID) would this work and be supported? Thanks for the help.43Views0likes1CommentReadyAPI certification
Dear, I will probably try to do the ReadyAPI certification soon. - I know you have two attempts to pass it. But what if you fail twice? Then it is game-over or can you re-buy it and re-do it twice more? - Suppose I buy the ReadyAPI On-Demand Video Training + certification TODAY. How much time do I have to do the exam? 1 month? A year? Unlimited in time? Thanks in advance for the responsesSolved681Views0likes1Comment