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:

Tags: , , , , ,
3 Responses to “SQL Server 2005 named instance in Oracle SQL Developer”
  1. vahidNo Gravatar says:

    you saved my life man.

  2. Edwin AriasNo Gravatar says:

    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:

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

Leave a Reply