I am trying to use SQL Developer to migrate several SQL server database's into Oracle. Some of them are hosted in a SQL Server 2000 instance and the rest are on SQL Server 2005. I am able to connect to the SQL Server 2000 databases without issue, but not the 2005 databases. I have followed every step in several different forum posts all to no avail. Why is SQL Developer fine with the 2000 instances, but flatly refuses to connect to the 2005's? I have zero problems connecting to the databases using TOAD or Management studio.
1. I am having this same issue with SQL Developer versions 2.11, 3.1.0.7 and also 4.0.3.16
2. TC/IP is enabled
2. I am using the 1.2 jar file
3. I have put the SSO folder in my PATH
4. I have copied the ntlmauth.dll file to every bin directory I can find
5. I've also copied the JtdsXA.dll to every bin directory I can find.
6. I know exactly what my port numbers are, and they are NOT 1433.
7. I have tried every combination of connection name, and port with and without database and instance name added.
8. I have a valid account and password set up using SQL Server authentication, and I also have a valid account using windows authentication that have both been verified by using TOAD and Management Studio.
9. I am also receiving the following error trying to use windows authentication through SQL Developer and have followed all instructions I could find to fix it to no avail: Status : Failure -I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property.