WebLogic Server Frequently Asked Questions

FAQs: WebLogic jDriver for MSSQL Server

• Can the Weblogic JDriver for MSSSQL Server connect to the database server using a trusted connection on NT/WIN2K?
• How do I connect to an SQL Server instance that is running on a machine with multiple instances of SQL Server 2000?

Q. Can the Weblogic JDriver for MSSSQL Server connect to the database server using a trusted connection on NT/WIN2K?

A. Our driver doesn't support trusted connections.

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

A. 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.