ffthmrc
New Contributor
Joined 4 years ago
User Profile
User Widgets
Contributions
Azure DB connection string template for JDBC connection
Hi, We switched to Azure and ReadyAPI Database connection string is changed(for JCDB steps). Doesn't need user and password. There are additional properties, We should able to connect to Azure DB without user. However, when I use "com.microsoft.sqlserver.jdbc.SQLServerDriver" as driver.it force me fill out user. Driver is MSSQL(MicrosoftDriver)/com.microsoft.sqlserver.jdbc.SQLServerDriver Connection string structure with properties : jdbc:sqlserver://<HOSTname>;database=<DBName>;encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30;Authentication=ActiveDirectoryIntegrated As you see there is no User in String. Do I need to add new Driver template or Should I create User ? Also Do I need to change proxy? Which Driver is relevant for Azure and Where can I download.