Install oracle sql developer on mac1/21/2024 Save and extract the contents of the fileģ. Then I restarted SQL Developer and it all worked fine □īelow steps worked for me to enable you to create and connect to SQL server connection instance in SQL developer.ġ.ĝownload the jTDS(jtds-1.2-dist) 3rd party JDBC driver.Ģ. …I quickly found a work around, which involved copying the “.\jtds-1.2\圆4\SSO\ntlmauth.dll” file from the jTDS directory to the “%JAVA_HOME%\jre\bin” folder. Status : Failure -I/O Error: SSO Failed: Native SSPI library not loaded. UPDATE: If you at any point decide to use Windows authentication to connect (like I just did), then you might hit this error: You’ll notice from the screen shot above that you can also use this to connect to Sybase databases, although I’ve not tried this out myself. Click “Retrieve database” and select the appropriate database, then Save/Test/Connect as you would do normally.Enter the following details: Connection Name (required for database retrieval), Username, Password, Hostname, and Port.Create a new connection, and choose the “SQLServer” tab.Click “Add Entry”, point to the ‘jtds-1.2.8.jar’ file location, then select it and click OK.Start SQL Developer go to Tools > Preferences > Database > Third Party JDBC Drivers.Save and extract the contents of the jtds-1.2.8-dist.zip file somewhere safe (I extracted mine under “C:\oracle\sqldeveloper\add-ons\jtds-1.2.8-dist\”).Download the jTDS 3rd party JDBC driver, version 1.2.8 from here (I’ve not personally tested with other versions).Apparently, being able to use Oracle’s SQL Developer to connect to SQL Server databases has been around for a while (via third party drivers), but I only started using it today for the first time, with SQL Developer 4 EA2 after my colleague mentioned it to me this afternoon □įirst of all, thanks to DJ’s blog here as a base for the instructions that follow.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |