BEA Home | Events | Solutions | Partners | Products | Services | Download | Developer Center | WebSUPPORT
| WebLogic Server Doc Home | FAQ | Previous Topic | Next Topic | Contents | View as PDF

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?

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

Our driver doesn't support trusted connections. Supporting trusted connections would result in the driver no longer being of type-4.

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

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.

Copyright © 2001 BEA Systems, Inc. All rights reserved. Required browser: Netscape 4.0 or higher, or Microsoft Internet Explorer 4.0 or higher.