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 Cloud Cruiser:

5. Configure Windows auth
with SQL Server

You can use Cloud Cruiser 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 Cloud Cruiser’s application server.

To enable Cloud Cruiser 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 Cloud Cruiser 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 Cloud Cruiser 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 Cloud Cruiser 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 Cloud Cruiser 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 Cloud Cruiser 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