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

Version 10

    Verified Product Versions

    Endpoint Manager 9.5Endpoint Manager 9.6Endpoint Manager 2016.xEndpoint Manager 2018.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



    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.



    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.
    2. Paste the copied text into Server name field on Connect to Server page of SQL Server Management Studio, click Connect.
      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.



    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.