Java can't connect to named instance of SQL server 2005

Hi

I'm having an issue connecting to a named instance of SQL Server 2005 from within a Java program.
I'm issuing the following command:

if( dbtype.equals("ora") )
{    Packages.java.sql.DriverManager.registerDriver( new Packages.mks.frame.sql.jdbc.oracle.Driver() );
}
if( dbtype.equals("sql") )
{    Packages.java.sql.DriverManager.registerDriver( new Packages.mks.frame.sql.jdbc.mssql.Driver() );
}
con = new Packages.java.sql.DriverManager.getConnection( url, dbuser, dbpass );
con.setTransactionIsolation( java.sql.Connection.TRANSACTION_READ_COMMITTED );

The variable "url" is set to:
jdbc:jtds:sqlserver://cgcsqldev\\sql2005:1433/Ticket_System

When I run the command, I get the following exception:
      java.sql.SQLException: Unknown server host name 'cgcsqldev\sql2005'.

I've been reading that Java doesn't like named instances of SQL server. The identified solution was to use the default instance and specify a port number since, technically, each instance should be running on its own port. However, this is not the case at the client that I am at right now. All instances (named and default) are listening on port 1433.

Is there any way for me to connect to a named instance of SQL Server 2005 through Java without requiring that it use a different port?

Thanks a lot.
ilakicAsked:
Who is Participating?
 
Marten RuneConnect With a Mentor SQL Expert/Infrastructure ArchitectCommented:
No. but you can find out witch port your named instance is using.

Fire up 'SQL Server Configuration Manager' and from there its easy. Now connect using this port.

/Marten
0
 
James MurrellProduct SpecialistCommented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.