Andrei DANEASA

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]

Good luck!

Related posts:

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.