How to access the default database of LDMS using Microsoft SQL Server Management Studio (SSMS).

Version 8

    Verified Product Versions

    LANDESK Management Suite 9.5LANDESK Management Suite 9.6LANDESK Management Suite 2016.x

     

     

    After you installed Endpoint Manager, you probably want to access the default database to manage it.

     

    This document gives the basic method to access the default database, ulddb. SQL Server 2014 is used in this document.

    Note: Please follow the instructions from your database admin to perform a backup before changes are made. You can find more information at Database backup and migration to a new SQL Server

     

    Steps

    Install SQL Server 2014.

     

    Follow the instructions from Microsoft to complete the setup of SQL Server 2014.

    During the installation, the default instance for LDMS96 will be detected, If you install the SQL Server on the same machine that LDMS96 is in-place.

    dco1.JPG

     

    After the setup is complete, launch the SQL Server Management Studio. You can just search for "SSMS" from your start menu in order to find it quickly.

     

    NOTE: If you have installed the SQL Express bundled install with LANDESK, we do not include SSMS.

                You will need to download and install it separately on the LDMS core server. Please see SQL Server Management Studio (SSMS) Landing Page.

     

     

    From the LDMS core console:

     

    1. Navigate to Configure --> Service -->select General tab, copy the entire text under Server text box.
      doc4.PNG
    2. Paste the copied text into Server name field on Connect to Server page of SQL Server Management Studio, click Connect.
      doc2.PNG
      Note: Here, the server name for LDMS96 is servername\instancename.

     

    Now, you can access and explore the database ulddb and manage it with SQL Server Management Studio.

    doc3.PNG

     

    If you want, you can create a new login for database ulddb and update this new login credential in Configure\Service within LDMS96 core console.

    Please restart the related SQL server service (better to restart the computer) for all changes in SQL Server to take effect.