1. From the PingFederate administrative console, go to System > Data Stores and click Add New Data Store.
  2. On the Data Store Type tab, in the Name field, enter a name.
  3. From the Type list, select Database (JDBC). Click Next.
  4. On the Database Config tab, in the JDBC URL field enter jdbc:sqlserver://<databaseservername>;<databaseName=databasename>;integratedSecurity=true. Click Add.

    Use the fully qualified domain name for your server. Port 1433 is the default port for SQL server. If you are using port 1433, then you can omit it from the JDBC URL. For any non-standard ports, specify them in the URL.

    integratedSecurity=true makes the connection use Windows authentication. Without that, it attempts SQL authentication.

  5. In the Driver Class field, enter com.microsoft.sqlserver.jdbc.SQLServerDriver.
  6. Complete the Username and Password fields with the same service account credentials from step 1.
  7. In the Validate Connection SQL field, enter SELECT getdate().

    SELECT getdate() is used to re-establish the JDBC connection if it gets disconnected.

  8. Click Next, and then click Save.
  9. Replicate the cluster configuration.