

SQL Server 2005 named instance in Oracle SQL Developer
Posted by: Andrei in Database, OracleI’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:
you saved my life man.
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
Ahh thank you… Looks pretty strange, but works good 🙂