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:


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:


For me it worked :)