« 
 »
22 05 2009

SQL Server 2005 named instance in Oracle SQL Developer

Posted by: Andrei in Database, Oracle

I’ve been told that there is no way to connect to a SQL Server 2005 named instance from SQL Developer. That’s not necessary true, but it’s strange.

A bit of background information: SQL Developer is connecting to SQL Server through JTDS opensource driver. The driver said that it cannot support named instances. On the other hand, in the connection string, there is a syntax for named instance, like “instance=your_instance“.

What you’ll have to do to connect to a named instance is not putting the instance name in the server name, like ADANEASA-RO/SQLEXPRESS, but concatenate everything in the port field.
Your port should be like [PORT]/[DB_NAME];INSTANCE=[INSTANCE_NAME]namedinstancesd

Good luck!

Related posts:

Related Posts

Sovrn
Tags: , , , , ,

This entry was posted on Friday, May 22nd, 2009 at 11:19 am and is filed under Database, Oracle.You can follow any responses to this entry through the RSS 2.0 feed.You can leave a response, or trackback from your own site.

3 Responses to “SQL Server 2005 named instance in Oracle SQL Developer”
  1. vahidNo Gravatar says:
    July 22nd, 2013 at 12:45 pm

    you saved my life man.

  2. Edwin AriasNo Gravatar says:
    August 6th, 2013 at 10:23 pm

    You are great!!!!

    I had spent a lot time trying to connect to MS SQL Server Instance from Oracle SQL Developer and nothing work.

    Thank for the information.

    Edwin

  3. BennyNo Gravatar says:
    August 20th, 2013 at 4:34 pm

    Ahh thank you… Looks pretty strange, but works good 🙂

Leave a Reply