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
- 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.
- 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. - At the end of the line that sets the
jdbc.url
property, append ;domain=<ADdomain>
. - 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==
- Create an Active Directory account that will be used for logging on to the HPE Consumption Analytics Portal database.
- 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:
- On the General page, set Login name to the desired Windows AD account and select Windows authentication.
- 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
. - In the Database role membership table, select
db_owner
and public
.
- (optional) Disable the logins ccadmin and ccreport, which were created by the installer but are not needed when using Windows authentication.
- Open the Services administrative tool in Windows on the HPE Consumption Analytics Portal server.
- Double-click the Cloud Cruiser service to open its properties, then click the Log On tab.
- For Log on as, select This account. Then in the adjacent fields, provide the username and password of the desired domain user account.
- 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.