0

I want to connect an SQL Server Database hosted in Azure configured with MFS from Oracle SQL-Developer.

Currently I am able to connect to this db server using SSMS just by putting the Server Name, user name & password, Default Network Protocol and choosing the Authentication type as 'Azure Active Directory - Universal with MFA.

But when using SQL-Developer it asks for Http/Https, Hostname, Port, Server Path & Service Name where I don't know what should be entered.

I tried by only entering the URL (the server Name I use is SSMS), but it failed to connect.

Do anyone know how I can make the connection successful?

Screenshot

Happiness
  • 21
  • 5

1 Answers1

0

To access the Azure SQL database in the Oracle SQL developer tool, you must download the JTDC driver which will be useful to connect to third party database.

I am able to make the successful connection from SQL developer tool to Azure SQL database by following below procedure:

  • Download the latest JTDC jar file from the URL below: https://sourceforge.net/projects/jtds/

  • Upload the jar file in the below path: Tools>>preferences>>Database>>Third Party JDBC driver enter image description here

  • After that, trigger the new connection from the developer tool and then you can get option to select SQL server enter image description here

  • Give the connection name, credentials and host name to access the database. enter image description here

From SSMS:

enter image description here

From SQL Developer tool:

enter image description here

Sourav
  • 814
  • 1
  • 9
  • Hi Sourav, I had tried this but I had to use the user name as myemail@MyServerURL as I use Azure AD login(my email is my user name) and SQL Developer takes the text after @ as the server url. I appended ;ssl=request (ssl=require as well) along with my server url in the hostname field because without that I was getting the error mentioned in https://stackoverflow.com/questions/67310070/is-there-anyway-to-connect-to-azure-sql-server-using-jtds-with-tls-1-2. But even after this I am getting Login Failed error message. – Happiness Dec 29 '22 at 17:51
  • Please raise this concern on [MS Q&A] (docs.microsoft.com/en-us/answers/questions/ask.html) or reach out to Microsoft support. – Sourav Jan 02 '23 at 11:45