Create the SQL Server data source

Before you begin

Before proceeding, complete Create the SQL Server JDBC provider.

Procedure

  1. Open the WebSphere Administrative Console if it is not already open.
  2. If you do not yet have a J2C (Java 2 Connector) authentication alias, create a new one.
    1. Click Global J2C authentication alias.
    2. Click New.
    3. Enter the following.

      Parameter

      Value

      Alias

      A string specifying the alias name, for example pcAlias.

      User ID

      A string specifying the user name.

      Password

      A string specifying the password.
    4. Click OK.
    5. Click Save to apply your changes to the master configuration.
  3. Choose Resources > JDBC > JDBC Providers.
  4. Set the Scope to Cell.
  5. Select the JDBC provider that you created for SQL Server.
    WebSphere displays the Configuration tab.
  6. Select Data Sources in the Additional Properties section.
    WebSphere displays the Data sources screen.
  7. Click New to create a new data source and enter a value for JNDI name.
    For example, enter something such as jdbc/pcDataSource.

    The JNDI name must match the value of the datasource-name attribute of the <jndi-connection-pool> element in the database-config.xml file. See Configure PolicyCenter to use a direct JNDI data source.

  8. Click Next.
  9. Enter the Database name.
  10. If using a different port to connect to the database than the default of 1433, change the Port number value.
  11. Enter the Server name for the server hosting SQL Server.
  12. Uncheck the box for Use this data source in container managed persistence (CMP).
  13. Click Next.
  14. Select an authentication alias for Component-managed authentication alias.
  15. Select an authentication alias for Container-managed authentication alias.
  16. Click Next.
  17. Review the information on the Summary screen. Do one of the following:
    • Click Previous if you need to make changes.
    • Otherwise, click Finish.
  18. Click Save to apply your changes to the master configuration.

What to do next

After completing this procedure, proceed to Configure the SQL Server data source properties.