No, the Services on the same Port and same IP. SQL Server allow up to 99 Instances on one machine. Only the Instance Name is important to identify the correct Instance. But how I can Access a SQL Server by Instance with Tomcat? Alex
________________________________ From: David Smith [mailto:[EMAIL PROTECTED] Sent: Tue 4/22/2008 12:50 PM To: Tomcat Users List Subject: Re: Access SQL Server 2005 and 2000 on same machine Ok... how do you get two services on the same port? Are they bound to different IPs? They can't both respond on the same address and port. --David Alexander Diedler wrote: > Hello, > We have installed a SQL 2000 and SQL 2005 Server Express on the same server > and same Port (1433) > Now we have no chance to tell the Tomcat in Conf Directory, which SQL Server > Version and Database has to be choosen for the Application. > I know, that there are Instance Names like 127.0.0.1\sqlexpress or > 127.0.0.1\default but how use it in Tomcat 6.0.14 on Windows 2003 Server? > Here a Example from /conf/Catalina/localhost/root.xml > > <Resource name="jdbc/jTDS" > auth="Container" > type="javax.sql.DataSource" > maxActive="100" > maxIdle="30" > maxWait="10000" > username="sa" > password="xxx" > removeAbandoned="true" > removeAbandonedTimeout="60" > logAbandoned="true" > driverClassName="net.sourceforge.jtds.jdbc.Driver" > url="jdbc:jtds:sqlserver://testsqlserver:1433/tecracer4;charset=Cp1252" > /> > > > > --------------------------------------------------------------------- > To start a new topic, e-mail: users@tomcat.apache.org > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
