Monday, April 5, 2010

Connecting SQL SERVER 2005 from SQL Developer 1.5.1

The Following Steps would explain the Setup

Step1: Download the "jtds-1.2.5-dist.zip" from http://sourceforge.net/projects/jtds/files/jtds/1.2.5/jtds-1.2.5-dist.zip/download

Step2: Open the Sql Developer
Tools -> Preferences -> DataBase ->Third Party JDBC Drivers
and add the "jtds-1.2.5.jar" which you have unzip from the step1. and OK.

Step3 : Right Click and select the "New Connection" at the "Connection" Node.
You could see sqlserver and sybase tabs have come. Click sqlserver tab. and fill the required
info. and click test. You may get the following error.
"I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property."
To overcome:
Copy the file 'jtds-1.2.2-dist\x86\SSO\ntlmauth.dll' from the unzipped JTDS and paste it at
sql_devloper_home\jdk\jre\bin.
Then restart SQL Developer.
Now you are done.
References :
http://www.oracle.com/technology/oramag/oracle/08-may/o38sql.html
http://www.dbforums.com/microsoft-sql-server/1612362-java-sql-sqlexception-i-o-error-sso-failed-native-sspi-library-not-loaded.html

No comments:

Post a Comment