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 :)
nice
Brilliant! Thank you very much. This definitely works!
Spent half a day almost trying to figure it out!
Thanks. After doing a long google search..finally I found this and brilliant and simple.
Thanks, much appreciated!
Good job.. Thanks lot…
Superb. Spot on
Thanks a lot. This worked for me as well but when i connect its loading all the database in the server without database objects except users(no tables, procedures, functions etc.). Can you give the solution.
I’m not sure… I actually did this only once of twice.
It sounds a bit like if you don’t have the rights to show database objects.
Users are not part of the databases in SQL Server if I remember correctly.
Not the latest version of SQL Developer of a very new version of SQL Server perhaps?
Sorry that I can’t help you further with this.
Regards, Ian.
thanks, now I got it.