connection issue to connect the sql server using oracle sqldeveloper

Question

connection issue to connect the sql server using oracle sqldeveloper

AAkula

SSCertifiable

Points: 5394
More actions
November 5, 2008 at 1:56 am

#124597

Hi,
We are using oracle sqldeveloper to connet to sql server. Iam getting the following error:
Status failure test failed i\o error:SSo failed. Native sspi library not allowed. check the java .library.path system property.
coukd you plz help how cwn we connect to sql server, I also attached screen shot

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

enriqecc Valued Member Points: 61 More actions · Answer 1

Here is what i did to make it run.

1. We need to install the jdbc drivers for sql server, i use the jtds driver (information about this http://jtds.sourceforge.net/) or download the driver from microsoft "Not tested yet in sql developer".

2. Once you have installed the driver yo need to update the reference to that driver inside sql developer.

- Go to menu tools then preferences.

Then in the preferences window expand option DataBase, and then select third part JDBC drivers and add the driver yo need to select the location where you installed the jdbc driver and click ok.

3. Create your database and test.

All this should work, hope this work for you.

jgrubb SSCrazy Points: 2542 More actions · Answer 2

First, did you install the JDBC driver correctly? Second, I've found using Windows auth with Java apps to be problematic.

TRACEY-320982 SSChampion Points: 13653 More actions · Answer 3

So your on ORACLE and connectioning to SQL - so as long as you have drivers installed thats how you connect these two together.

Is oracle sql developer come with Oracle .....

We will be doing this soon....

Kishore.P SSCrazy Eights Points: 8147 More actions · Answer 4

First you need to install relevant JDBC / ODBC drivers to access SQL Server 2000 and below version, for SQL 2005 and above you need install SQL Native Client for SQL server and also install SQL JDBC Drivers from Microsoft.

jgrubb SSCrazy Points: 2542 More actions · Answer 5

TRACEY (11/6/2008)
So your on ORACLE and connectioning to SQL - so as long as you have drivers installed thats how you connect these two together.
Is oracle sql developer come with Oracle .....
We will be doing this soon....

This is not the same thing. Oracle Developer is an IDE. You can use it to develop Java apps that connect, but they are not connecting Oracle to SQL Server. It's more like an application connecting to 2 different DB's.

You can use Oracle Heterogeneous Services to to create a link to the SQL Server, just like you can create a Linked Server from SQL to Oracle. It would then "look" like the other server, and try and translate the queries. As you can guess, it's not completely transparent.

TRACEY-320982 SSChampion Points: 13653 More actions · Answer 6

Thanks i have to keep mental note set it up like linked server even better.

madhu-686862 SSChampion Points: 10707 More actions · Answer 7

hi

I successfully connected to the sql server by doing this...

Copy the file 'jtds-1.2.2-dist\x86\SSOtlmauth.dll' from the unzipped to JTDS --> \jdk\jre\bin. After this i restartet the SQL Developer.

Now the connection to my SQL Server works fine .

jozef.deherdt Valued Member Points: 67 More actions · Answer 8

Can you specify what a correct installation of the jdts driver is? (details please)

The copy of the dll dit not work

nickie-1157518 SSC Journeyman Points: 87 More actions · Answer 9

madhu (11/6/2008)
hi
I successfully connected to the sql server by doing this...
Copy the file 'jtds-1.2.2-dist\x86\SSOtlmauth.dll' from the unzipped to JTDS --> \jdk\jre\bin. After this i restartet the SQL Developer.
Now the connection to my SQL Server works fine .

Great !! Thanks !! I now can connect to sql server express

after copy the dll.

If just adding the jdbc .jar file is not enough

Copy the dll make it successful

Thanks again

mouudddy Grasshopper Points: 19 More actions · Answer 10

Hi All, I was just trying to find a solution for my problem, and I found some questions which I think I have answers for...

1st Oracle SQL Developer is a stand alone application (Something like Toad) made by Oracle...

This Link contains good explanation from Oracel http://www.oracle.com/technology/oramag/oracle/07-sep/o57sql.html

Download link for Oracle SQL Developer is http://www.oracle.com/technology/products/database/sql_developer/index.html ( I guess u will need oracle user/pass)

2nd Under the first link u shall find information about Jtds and download link...

for connection using WIN auth. here is the steps: (note I copied it from another forum for honesty)..

1) Install/Extract SQL Developer 1.2.1 in C:\Program Files\Oracle

Making the {$sqldevhome} = C:\Program Files\Oracle\sqldeveloper

2) Obtain the JDBC SQL SERVER Pluggin (jtds-1.2.2-dist.zip) from:

http://sourceforge.net/project/showfiles.php?group_id=33291&package_id=25350

3) Unzip jtds-1.2.2-dist.zip

Creates: jtds-1.2.2.jar

\x86\SSOtlmauth.dll

4) Copy the jtds-1.2.2.jar into:

{$sqldevhome}\jlib Directory.

5) Copy the the ntlmauth.dll dll in the \x86\SSO subdir into:

{$sqldevhome}\jdk\jre\bintlmauth.dll

6) In SQL Developer:

Go to Menu "Tools"

- Preferences...

Expand the "[+] Database

Choose "Third Party JDBC Drivers"

Click "Add Entry"

Then Browse for your copy of "{$sqldevhome}\jlib\jtds-1.2.2.jar"

Note: Use the jar filename, not its parent directory for entry.

7) Restart SQL Developer and try your SQL Server 2000 (or SQL Server 2005) Connection

...

Wish my reply is helpful for others....

a by the way my problem is after doing all that and trying to connect to SQL server i receive this error

"Status : Failure -Cannot connect to Microsoft SQL Server on IP"

Good luck...