Hey
ffthmrc,
I wouldve suggested that youre getting prompted for a user cos thats one of the parameters specified in the connection string associated with the "com.microsoft.sqlserver.jdbc.SQLServerDriver" driver youre specifying but youre saying your connection string associated with that driver doesnt include a user parm....so i dont understand whats going on there....screenshots of your jdbc settings might help.....???
However. You need to identify the correct driver you need and ensure the connection string set is correct. Speak to the DBA's involved on your project to confirm the version of Azure SQL DB youre connecting to.
Then google for the correct driver and download. Forum users wont be able to tell you what driver to use....you need to find out the version of Azure SQL DB youre trying to connect to and then pickup the correct driver via google.
Then create a new jdbc connection in your settings specifying the correct connection string.
That should sort. Are you sure you need a JDBC connection? You can query Azure SQL DB via REST.
Cheers,
Rich
