Dan: It may be related to which JDBC driver you're using. I've never had much success using the Microsoft SQL JDBC driver to connect to a named instance by using the instance name. I've only been able to connect by finding out which port the instance is using, and specifying that in the connection URL.
I have had success using the JTDS driver - it's an open source, pure Java (type 4) JDBC 3.0 driver for Microsoft SQL Server (and Sybase), which has worked just fine when I use the instance name in the URL. You can find it at: http://jtds.sourceforge.net Good luck! Thanks, Johnny "Dan Decker" <[EMAIL PROTECTED]> 10/11/2006 07:27 PM Please respond to "Tomcat Users List" <users@tomcat.apache.org> To <users@tomcat.apache.org> cc Subject Tomcat using MS SQL2000 Named Instance I am trying to get Tomcat to connect to a MS SQL2000 Named instance rather than the default instance. Using the following it connects to the database TWO on the default server KEYSTONE with no problems. jdbc:sqlserver://KEYSTONE;databaseName=TWO When I try to access the MS SQL2000 named instance KEYSTONE\GP90 it still connects to the default jdbc:sqlserver://KEYSTONE;instanceName=GP90;databaseName=TWO Dan Decker
