skip to main | skip to sidebar

Eric's Oracle and SQL Server Tips

The Sky is The Limit!

Apr 13, 2009

Issues to access SQL Server in Oracle SQL Developer

1. Failed when tried to connect to a SQL server.

Error Message: Status: Failure -I/O Error: SSo Failed: Native SSPI library not loaded. Check the java.library.path system property.

Fix: Copy \x86\SSO\ntlmauth.dll to \jdk\jre\bin

2. How to connect a named SQL server instance.

In SQLServer tab:

Hostname:
Port: /;instance=

Ex: 1433/EDW_SA;instance=edw_dev

Seems it(1.5.4) doesn't support schema.
Posted by emao at Monday, April 13, 2009
Newer Post Older Post Home

Blog Archive

  • ▼  2009 (5)
    • ►  May (2)
    • ▼  April (1)
      • Issues to access SQL Server in Oracle SQL Developer
    • ►  February (2)
  • ►  2008 (9)
    • ►  June (1)
    • ►  May (5)
    • ►  March (3)
  • ►  2007 (11)
    • ►  October (2)
    • ►  August (2)
    • ►  July (2)
    • ►  June (3)
    • ►  April (1)
    • ►  March (1)
  • ►  2006 (19)
    • ►  December (3)
    • ►  October (1)
    • ►  September (4)
    • ►  June (1)
    • ►  May (1)
    • ►  April (9)
  • ►  2005 (16)
    • ►  October (2)
    • ►  August (2)
    • ►  July (6)
    • ►  June (6)
  • ►  2003 (3)
    • ►  August (2)
    • ►  July (1)

My Links

  • Orca for Oracle Database Monitoring
  • My Favorite Links
  • My Notes

Oracle on Linux

  • Oracle | Linux Technology
  • P U S C H I T Z . C O M

Database Security&Benchmark

  • Oracle Security from PeteFinnigan.com Limited
  • NIST Security Configuration Checklists Repository
  • The Center of Internet Security

Beyond English

  • VOCATIONAL - Communications Skills
  • Peak English
  • GoEnglish.com Pocket English Idioms