# Support and restrictions for 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 Microsoft SQL Server 2000 Driver for JDBC is supported for Microsoft SQL Server.

Microsoft SQL Server 2000 Driver for JDBC

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

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.

(C) Copyright IBM Corporation 2000, 2005. All Rights Reserved.