Unsupported content This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

Selecting Microsoft SQL Server as a data source for BMC Remedy AR System

This section explains the following procedures:

Allowing Microsoft SQL Server 2008 as a data source for BMC Remedy AR System

You can select Microsoft SQL Server 2008 as a data source for BMC Remedy AR System:

  1. Go to the Admin Console for BMC Dashboards for BSM and on the BMC Dashboards for BSM Login screen, enter your administrator login ID and password.
  2. Click Login.
  3. Go to Data Source Configuration > BMC Remedy AR System Server and click the Connection tab.
  4. For the Database Type field, select Microsoft SQL Server 2008 from the drop-down menu.
  5. Fill in the required information for the remaining fields and click Save.

Allowing Microsoft SQL Server 2012 as a data source for BMC Remedy AR System

You can select Microsoft SQL Server 2012 as a data source for BMC Remedy AR System:

  1. Go to the Admin Console for BMC Dashboards for BSM and on the BMC Dashboards for BSM Login screen, enter your administrator login ID and password.
  2. Click Login.
  3. Go to Data Source Configuration > BMC Remedy AR System Server and click the Connection tab.
  4. For the Database Type field, select Microsoft SQL Server 2012 from the drop-down menu.
  5. Fill in the required information for the remaining fields and click Save.

Creating a custom data source for Microsoft SQL Server 2012

Follow the steps given below to create a custom data source for Microsoft SQL Server 2012:

  1. Go to the Admin Console for BMC Dashboards for BSM and on the BMC Dashboards for BSM Login screen, enter your administrator login ID and password.
  2. Click Login.
  3. Go to Data Source Configuration > Custom Data Sources and click New Custom Data Source.
  4. Under the Database Properties section, for the Database Type field, select Microsoft SQL Server 2012.
  5. Fill in the required information for the remaining fields and click Save.

Creating a custom data source for Microsoft SQL Server 2008 Windows Authentication or Microsoft SQL Server 2012 Windows Authentication

Follow the steps given below to create a custom data source for Microsoft SQL Server Windows Authentication:

  1. Go to the Admin Console for BMC Dashboards for BSM and on the BMC Dashboards for BSM Login screen, enter your administrator login ID and password.
  2. Click Login.
  3. Go to Data Source Configuration > Custom Data Sources and click New Custom Data Source.
  4. Under the Database Properties section, for the Database Type field, select either Microsoft SQL Server 2008 Windows Authentication or Microsoft SQL Server 2012 Windows Authentication.
  5. Fill in the required information for the remaining fields and click Save.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*