Wednesday, May 9, 2012

SQL Server Connection from Oracle SQL Developer

Connection from SQL Developer to MS SQL.
1.Download jtds-1.2.5-dist
2.Extract Files
3.Go to SQL Developer's TOOL Menu-->Preferences-->Search like Third Party JDBC



4.Click Add Entry -->Add jtds-1.2.5.jar File.
5.Search file ntlmauth.dll into @@jtds-1.2.5-dist\x86\SSO\
and  put into @@\Java\jre1.6.0_12\bin
6.Restart SQL Developer.
7.Go to New Connection and Tab of SQL Server.


8.Give username,password,hostname(instance name),TCP/IP Port.

Eg.


10.Test and Check Status as Success.

No comments:

Post a Comment

Dear User,

Thank you very much for your kind response