Installing and running Workspaces without a Service Desk installation

If you are a LANDESK Management Suite customer that doesn't have a LANDESK Service Desk license or installation, you can follow these steps to install and run Workspaces. These steps only apply to customers who will be running the Service Update 4 and Workspaces combo pack.

There are three main parts in this process:

  1. Core server preconfiguration
  2. Restore the Service Desk SQL database to your SQL Server
  3. Configure the Workspaces database connection
Part 1: Core server preconfiguration
  1. Download a SQL Server Service Desk database backup self-extracting file:
    US: http://download.landesk.com/product/ServiceDesk/2016.2/service_desk_2016.2_ootb.exe
    EMEA: ftp://download2.landesk.com/pub/product/ServiceDesk/2016.2/service_desk_2016.2_ootb.exe
  2. Run the self-extracting executable.
  3. Restore the database to your SQL Server by following the steps in the next section.
  4. Run the LDMS 2016.2 (SU 4) with Workspaces install from the LDMS download site.
  5. Once the install finishes, Configuration Center will automatically launch after the server is rebooted and the first login.
Part 2: Restore the Service Desk SQL database to your SQL Server

If you are an SQL Server customer, contact your corporate DBA in order to restore the database on the same SQL Server that the LDMS core database is running on. The DBA will need to provide the database server name, a valid database user and password for use later in the configuration.

If you are an SQL Express customer, follow these steps:

  1. If you haven’t already downloaded SQL Server Management Studio for SQL Express and installed on the core, do so from Microsoft.com at
    https://msdn.microsoft.com/en-us/library/mt238290.aspx
  2. Open SQL Server Management Studio and connect to the SQL Express instance on your core server.
  3. When prompted for the server name, use <CoreServer>\LDMSDATA. Use Windows Authentication.
  4. Expand the root node in the tree.
  5. Right-click on Databases and choose Restore Database…
  6. Click on the “Device” radio button.
  7. Click on the “…” button to select the backup file (*.bak) in the folder you used for the self-extracting database backup.
  8. Click “Add” button.
  9. Locate the backup file required from part 1 step 4 above and select the file making sure to choose your correct language file. Note that en_* is American English and eng_* is British English.

  10. Click OK from the “Locate Backup File” window.
  11. Click OK from the “Select backup devices” window
    .
  12. Under the “Destination” section of the “Restore Database” window, you can enter a new name for the database, or just keep the default. Note the name of the database to be used later in Configuration Center.
  13. Click OK in the “Restore Database” window to restore the database.
  14. Close the “Database successfully restored” dialog and validate that the database exists in SQL Service Management Suite.
  15. If they aren't there already, add Network Service and System as users in SQL Server Management Studio by following steps 16-19.
  16. Under the Security node, right-click Logins and click New Login.


  17. Click the Search button.


  18. Enter "Network Service" in the "Enter the object name to select" text box, then click Check Names.


  19. Click OK in the Select User or Group dialog box and in the Login - New Window.
  20. Repeat steps 16-19 for the System user if necessary.
  21. For the database you restored, add db_owner roles for both the System and Network Service by double-clicking the login for each, which opens the “Login Properties” dialog box. Select "User Mapping", select the database you restored, and select the db_owner check box.


  22. Follow the steps in the next section to finish configuring Workspaces.
Part 3: Configure the Workspaces database connection
  1. Within Configuration Center, click “Create Standard Instance” link.
  2. Leave the instance name set to “My”.
  3. Enter the database connection information for the restored workspace database. Note: SQL Express customers should use <CoreServerName>\LDMSDATA as the server name.
  4. If you're using SQL Express locally on the core server and you've followed the steps above, select “Integrated Security”. If you're using another SQL server/database, provide the credentials to access the database. The user must have db_owner access.

  5. Click “Test Connection” to make sure the connection works.
  6. Click OK.
  7. You should be taken to the edit page for the “My” instance.
  8. You can close your browser, Workspaces is now configured. If Configuration Center launched automatically after the upgrade and reboot, closing it will continue the user’s login. If you kept the default instance name, the Workspaces URL is http://<CoreServerName>/my.bridgeit.

 


Was this article useful?    

The topic was: