BEA Weblogic Interview Question:

How do I connect to an SQL Server instance that is running on a machine with multiple instances of SQL Server 2000?

Submitted by: Administrator

Each instance of MS SQL Server must be listening on a different port. So, you can use the port number in the properties that you pass to the getConnection() method or, in case of connection pools, you can specify the port property in the following properties:
server=machineName
port=instancePort

To find the port number where each MS SQL Server instance is running, run the server network utility (in the Microsoft SQL Server program group), select the server instance, select TCP/IP, and click the properties button.
Submitted by: Administrator