Configuring Windows authentication with SQL 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.password, reporting.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.

What to do next

To install HPE Consumption Analytics Portal: