How to use Configuration Center to set up a Workspaces Database

Version 15

    Verified Product Versions

    LANDESK Management Suite 9.6LANDESK Management Suite 2016.x

    Description

    This document will explain how to configure a Workspaces database both a new empty database, or point to an existing Workspaces\ServiceDesk database in LANDESK 2016.3.

     

    Configuration Center is a tool that has been part of the ServiceDesk product line for many years. With the release of Workspaces 2016.3 as part of LANDESK 2016.3 comes a new requirement for a database that is separate from the LADESK Database to retain all of the data specific to Workspaces such as charts, and user information. This new database is actually a fully serviceable ServiceDesk database, and so is easily integrated with ServiceDesk if desired. Another alternative to creating a new separate database, if you are using ServiceDesk as well in your environment, is that you can configure Configuration Center to integrate Workspaces into your ServiceDesk database. This integration of databases allows you to use Workspaces as a unified window into both your LANDESK and ServiceDesk environments. Configuration Center is the tool that is used to configure this new database, upgrade previous versions of the standalone Workspaces database, or integrate Workspaces into your existing ServiceDesk database.

     

    You will need to plan which approach you will take with your Workspaces database, whether you are going to setup a new clean database, if you are going to integrate with your existing ServiceDesk database, or if you are going to be upgrading an existing Workspaces database.

     

    Keep in mind that if you are upgrading an existing Workspaces database you will need to perform the steps in both of these sections of this document:

    • Configuring an existing Workspaces or ServiceDesk database
    • Upgrading an existing Workspaces database

    It is important to ensure this Workspaces database is configured or else you will NOT be able to use Workspaces until this is done. If you originally closed out of Configuration Center on accident do not worry, it is simply a matter of opening it back up and completing the steps below for your scenario.

     

    How to get to Configuration Center

    There are a couple different options to open Configuration Center from your LANDESK Core Server:

    -OR-

    • On the Core Server, click on Start - Applications - LANDESK - LANDESK Configuration Center

    -OR_

    • If you are installing LANDESK 2016.3, and are using a SQL Server to host your LANDESK database, instead of using the bundled SQL Express option, by default Configuration Center will automatically be opened at the first reboot after the install has completed successfully.

    Screen Shot 2016-10-19 at 8.29.02 AM.png

     

    Either one of these options will end with you having a browser open sitting at a certificate security warning screen. Since LANDESK uses self-signed certificates you will always have to click past this certificate warning unless you install the certificate in your servers trusted store. Please see this document for more information: Pre-Trusting the LANDesk Certificates

    Configuring a new Workspaces Database

    When installing\upgrading the LANDESK 2016.3 or later for the first time you have to setup a new, empty database container for Configuration Center to populate.

    Database Preparation

    • LANDESK Recommends creating your Workspaces database container in the same server and instance as the LANDESK database.
    • Container MUST be empty or Configuration Center will not allow it to be configured.
    • Database user must have DB_Owner permission to the database.

     

    Database Configuration

    1. On your Core Server open Configuration Center
    2. If you have no Workspaces database already populated you will automatically be presented with the Configure Workspaces Database prompt.
      Screen Shot 2016-10-19 at 9.38.43 AM.png
    3. Fill out the database connection information. Click Test Connection.
      Screen Shot 2016-10-19 at 10.22.10 AM.png
    4. Click Configure Database. The database configuration usually takes 3-5 minutes to complete.
      Screen Shot 2016-10-19 at 10.26.48 AM.png
    5. Once the database configuration is complete, click the Close button, and then you can close the browser window as well.
    6. Your new Workspaces database in configured and ready.

     

    Configuring an existing Workspaces or ServiceDesk database

     

    Configure the database

     

    The Configure Workspaces Database prompt only works when you are configuring a new and empty database. If you have an existing database for Workspaces or wish to integrate Workspaces with ServiceDesk you have to follow a different path to configure the database. This is procedure will walk you through how to setup your database connection and upgrade the database if necessary.

    If you are integrating with a ServiceDesk database that instance of ServiceDesk MUST be the same release level as LANDESK.

    1. On your Core Server open Configuration Center.
    2. If you do not already have a Workspaces database configured, you will receive the Configure Workspaces Database prompt that is used to configure a new database. This is not needed in our scenario, go ahead and hit the 'Cancel' button to close this prompt.
    3. You are now looking at the Configuration Center 'Current Instances' page. By default there is only one instance listed. By default it is called the 'My' instance.
    4. Click on the title of the 'My' instance.
      Screen Shot 2016-10-19 at 10.51.31 AM.png
    5. You are now looking at the My instance properties page. From here locate the 'My.Framework' line, on this line click the 'Edit' link.
      Screen Shot 2016-10-19 at 10.58.00 AM.png
    6. You will see a pop-up window titled 'Edit Application' and a sub-title of 'Service Desk Framework'. From here you will:
      1. Enter your database connection information.
      2. Test database connection.
      3. Enter STS Credentials.
      4. Test STS credentials.
      5. Click OK.
        Screen Shot 2016-10-19 at 1.13.52 PM.png
    7. If you have just pointed to a ServiceDesk database you are now done. And can close the browser. If you have pointed to an existing Workspaces database, please complete the next section as well.

     

    Upgrading an existing Workspaces database

     

    When using an existing Workspaces database we also have to perform an upgrade on the database to ensure it is at the correct level to support the installed version of Workspaces.

    1. From the 'My' instance properties page, click on the Edit link next to My.Framework again.
      Screen Shot 2016-10-19 at 1.24.23 PM.png
    2. You are now back at the 'Edit Application' - 'Service Desk Framework' pop-up window.
      1. Change the 'Logon Policy' option to 'Explicit Only'.
      2. Click OK.
        Screen Shot 2016-10-19 at 1.28.06 PM.png
    3. Back on the 'My' instance properties page, click on the Upgrade link next to My.Framework.
      Screen Shot 2016-10-19 at 1.24.23 PM.png
    4. On the 'Upgrade Details' pop-up that appears, validate the connection string and click on the 'Upgrade' button.
      Screen Shot 2016-10-19 at 1.32.17 PM.png
    5. Depending on how many operations have to be performed on the DB, this may take a few minutes.
      Screen Shot 2016-10-19 at 1.34.31 PM.png
    6. Once the upgrade is complete you'll see a message in the window indicates both steps have completed successfully. Once complete, click Close.
      Screen Shot 2016-10-19 at 1.36.48 PM.png
    7. Now that the database has been upgraded, we have to set the Logon Policy back to use 'Token Only' permissions.
    8. Click the Edit link next to My.Framework.
      Screen Shot 2016-10-19 at 1.40.46 PM.png
    9. You are now back at the 'Edit Application' - 'Service Desk Framework' pop-up window.
      1. Change the 'Logon Policy' option to 'Token Only'.
      2. Enter and test your STS Credentials.
      3. Click OK.
        Screen Shot 2016-10-19 at 1.43.52 PM.png
    10. You are now complete, and can close your browser.

     

    Conclusion

    Now that you have your Workspaces database configured you can begin enjoying the extra flexibility that Workspaces brings to your environment. If you ran into any error messages while working through these steps please review theHow to troubleshoot Configuration Center  document.