Microsoft SQL Server database connections

Use the New Database Connection wizard or pages that are embedded in other wizards to create a JDBC connection to Microsoft® SQL Server.
The following JDBC drivers are supported for Microsoft SQL Server:
  • Microsoft SQL Server 2000 Driver for JDBC
  • Microsoft SQLServer 2005 Driver for JDBC
  • IBM® WebSphere® SequeLink JDBC Driver
  • IBM WebSphere Connect JDBC Driver
Microsoft SQL Server 2000 Driver for JDBC

The Microsoft SQL Server 2000 Driver for JDBC is included with MS SQL Server 2000. This is licensed software that you must purchase from Microsoft.

You can download the JDBC driver Microsoft SQL Server 2000 Driver for JDBC from www.microsoft.com/sql.

Microsoft SQLServer 2005 Driver for JDBC
You can download this JDBC driver from Microsoft.

The IBM WebSphere SequeLink JDBC Driver and the IBM WebSphere Connect JDBC Driver are included with this product. For more information about setup and restrictions for these JDBC drivers, see the JDBC provider summary topic in the Websphere Application Server information center.

To retrieve tables that you do not own, you must have database role membership in the roles 'public' and 'db_datareader'.

To change the database role membership:
  1. Start the Microsoft SQL Server Enterprise Manager.
  2. Under the Console Root, open the Users folder under the database that you are working with. A list of users for this database is shown in the right hand pane.
  3. Right-click on the user that you want to change, and click Properties.
  4. Select the appropriate database role memberships in the list:
    db_datareader
    Read access
    db_datawriter
    Insert, update, and delete access
    db_ddladmin
    Table and view delete access
  5. Click OK.
Related concepts
Overview of database connections
Related tasks
Connecting to a database by using a wizard
Related reference
Connection Parameters page
Filter page
New or Existing Connection page

Feedback