Oracle SQL Developer and a SQL Server Instance

Sometimes… as Oracle DBA you need to connect to SQL Server (with Oracle SQL Developer and jTDS plug-in installed).

When using ‘SQL Server Management Studio’, the ‘Server name’ is in the format:

SERVERNAME\INSTANCE.

This won’t work in SQL Developer:

Status : Failure -Unknown server host name 'SERVERNAME\INSTANCE'.

This can be solved using the ‘hostname’ in the next format in SQL Developer:

SERVERNAME;instance=INSTANCE

For me it worked :)

Tagged . Bookmark the permalink.

6 Responses to Oracle SQL Developer and a SQL Server Instance

  1. Ismail Mohiddin says:

    Brilliant! Thank you very much. This definitely works!
    Spent half a day almost trying to figure it out!

  2. Rasik says:

    Thanks. After doing a long google search..finally I found this and brilliant and simple.

  3. Jawad says:

    Thanks, much appreciated!

  4. Kalaivendan says:

    Good job.. Thanks lot…

  5. Pavan says:

    Superb. Spot on

Leave a Reply

Your email address will not be published. Required fields are marked *