Create the SQL Server JDBC provider

Before you begin

Before proceeding, complete Copy the SQL Server JDBC driver to WebSphere.

Procedure

  1. Open the WebSphere Administrative Console if not already open.
  2. Choose Resources > JDBC > JDBC Providers.
  3. Set the Scope to Cell.
  4. Click New to create a new JDBC provider.
  5. Select SQL Server for the Database type.
  6. Select Microsoft SQL Server JDBC Driver for the Provider type drop down and click OK.
  7. Select Connection pool data source for the Implementation type.
  8. Supply a new Name for the JDBC provider, for example pcSQLServer.
  9. Enter a Description for the JDBC provider if you want.
  10. Click Next.
  11. Specify the directory location of mssql-jdbc-<version>.jar.

    Set the value to the WebSphere lib/ext directory, for example: 

    C:\Program Files\IBM\WebSphere\AppServer\lib\ext

    You can ignore the greyed out Class path box that lists the JAR name as sqljdbc.jar instead of mssql-jdbc-<version>.jar.

    You do not need to enter a value for Native library path.

  12. Click Next.
  13. Review the Summary screen and do one of the following:
    • Click Previous if you need to make changes.
    • Otherwise, click Finish.
  14. Click Save to apply your changes to the master configuration.
    WebSphere returns you to the JDBC Providers screen. At this point, you have completed the creation of the new provider.
  15. Select the JDBC provider you just created.
  16. Edit the value of Class path and change it from ${MICROSOFT_JDBC_DRIVER_PATH}/sqljdbc.jar to ${MICROSOFT_JDBC_DRIVER_PATH}/mssql-jdbc-<version>.jar.
  17. Click OK.
  18. Click Save to apply your changes to the master configuration.

What to do next

After completing this procedure, proceed to Create the SQL Server data source