Cloud Cruiser became HPE Consumption Analytics on Nov. 1st. You'll still see the old name in places while we update this site.

 

 

Consumption Analytics Documentation

Home > Cloud Cruiser 4 > Installing > Configuring Windows authentication with SQL Server

Configuring Windows authentication with SQL Server

Table of contents
No headers

This article is part of To install HPE Consumption Analytics Portal:

5. Configure Windows auth
with SQL Server

You can use HPE Consumption Analytics Portal with a Microsoft SQL Server system set for Windows authentication. There are two parts to this configuration: the database connection information and the Windows Active Directory (AD) account used by HPE Consumption Analytics Portal’s application server.

To enable HPE Consumption Analytics Portal to use Windows authentication

  1. If you provided your domain name as the Integrated Security Domain during installation as instructed in Installing the Cloud Cruiser application, skip to step 4. Otherwise, continue.
  2. On the machine where HPE Consumption Analytics Portal is installed open the file <install_dir>/apache-tomcat-7.0.54/webapps/ROOT/WEB-INF/classes/database.properties in a text editor.
  3. At the end of the line that sets the jdbc.url property, append ;domain=<ADdomain>.
  4. Disable each of the following parameters by adding a pound sign (#) to the beginning of its line: jdbc.username, jdbc.passwordreporting.username, and reporting.password.
    For example, if your SQL Server machine is named dbserver5 and your HPE Consumption Analytics Portal machine is a member of the AD domain cloudfinance.local, this section of your database properties would be:
    jdbc.driver=net.sourceforge.jtds.jdbc.Driver
    jdbc.url=jdbc:jtds:sqlserver://dbserver5:1433/ccdb;socketKeepAlive=true;domain=cloudfinance
    #jdbc.username=ccadmin
    #jdbc.password.encrypted=encrypted==
    hibernate.dialect=org.hibernate.dialect.SQLServerDialect
    validation.query=select 1
    #reporting.username=ccreport
    #reporting.password.encrypted=encrypted==
    
  5. Create an Active Directory account that will be used for logging on to the HPE Consumption Analytics Portal database.
  6. Using Microsoft SQL Server Management Studio, connect to your SQL Server database server. In the Security folder, create a new login with the following properties:
    1. On the General page, set Login name to the desired Windows AD account and select Windows authentication.
    2. On the User Mapping page, in the Users mapped to this login table, select the HPE Consumption Analytics Portal database and set its Default Schema to dbo.
    3. In the Database role membership table, select db_owner and public.
  7. (optional) Disable the logins ccadmin and ccreport, which were created by the installer but are not needed when using Windows authentication.
  8. Open the Services administrative tool in Windows on the HPE Consumption Analytics Portal server.
  9. Double-click the Cloud Cruiser service to open its properties, then click the Log On tab.
  10. For Log on as, select This account. Then in the adjacent fields, provide the username and password of the desired domain user account.
  11. Click OK to save these changes and close the Properties dialog box, then from the Action menu, choose  (Re)start.

The application server starts and connects to SQL Server using Windows authentication.

Last modified

Tags

Classifications

This page has no classifications.
© Copyright 2018 Hewlett Packard Enterprise Development LP