AppSense: Creating the EM database

We are in the midst of implementing AppSense to manage our Citrix users and eventually all users in the enterprise.  It has been hard to find information in the blogosphere which I find surprising.  AppSense is not a brand new product and its recent recognition by Citrix at this year’s Synergy leads me to believe that someone (other than AppSense sales) is talking about this product.  I would greatly appreciate if any readers of this blog could suggest any AppSense blogs they’ve come across.

Scenario

In most enterprise environments, there is compartmentalization of IT services and being on the Citrix team, I do not have sysadmin access to our enterprise MS SQL cluster.  This was not an issue when I setup the Management database as the service account for that DB only needs DBO privileges.  I spent several days pouring over AppSense documentation, searching Google, and communicating with my DBA and AppSense support to get this database created.  Partially, this was my fault because the documentation I had did not make the following steps clear to myself or my DBA.  I’m including the steps forwarded to me from AppSense support and the PDF they sent that describes this process.

  1. Create 2 accounts (Windows or SQL Accounts) – example AppSenseConfig and AppSenseService
  2. Ensure both of these accounts do not have an expiry on the password
  3. On the SQL Server, map the roles of Sysadmin to the AppSenseConfig account
  4. On the SQL Server, do not map any roles for the AppSenseService account
  5. Launch the Server Configuration Server and run the wizard using the 2 newly created accounts. At the first screen, enter the details from the AppSenseConfig account and point to the SQL Server and the existing database AppSenseEMDB
  6. At the next screen, enter the details of the AppSenseService account
  7. Complete the rest of the wizard.
  8. On completion, ensure that under the database tree, the AppSenseEMDB database is connected and not highlighted red. If any of the tree view items are marked red, select the Variances button, take a screenshot of the variance(s) and then select repair. If the variances cannot be fixed, contact AppSense support.
  9. Once the upgrade to the database has completed, you can remove the Sysadmin rights to the AppSenseConfig account as per the details in the PDF. This document explains all the roles during and post install of the accounts used in the setup of the database.

PDF: Installing AppSense Personalization Server with Limited Database Privilege.

Thanks,
Alain

Advertisements

One thought on “AppSense: Creating the EM database”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s