Layton ServiceDesk - Installation - New Installation - Install New Database

From Layton Support
Jump to: navigation, search

Btn back up.png Back to Contents



Though commonly done as part of a new installation, a new database can be created at any time. Layton ServiceDesk will only connect to one at a time. Creating an additional database is mostly for testing purposes or to start again with a new, blank database.


  1. Launch the Layton ServiceDesk Database Tool (C:\Program Files (x86)\Layton Technology\Layton ServiceDesk\DBTool\DBTool.exe), by opening the Windows Start menu > Layton Technology and right-clicking DBTool.exe and selecting More > Run as administrator.
  2. Click Install New Database:

    Lsd install 06.png

  3. Click the Select button next to the Server field. In the Select SQL Server dialog, select a SQL Server from the list, then click the Select button. This will populate the Server field in the main window.

    Lsd install 07.png

  4. Check the Use Trusted Connection checkbox. This will authenticate as the logged-in user. This user will need to have administrative permissions on the SQL Server to continue.

    Lsd install 08a.png

  5. Click the Test button to test the connection to the SQL Server with the provided details. If successful, a dialog will confirm:

    Lsd install 09a.png

  6. If not successful, uncheck the Use Trusted Connection checkbox and enter a SQL login ID such as sa:

    Lsd install 08b.png

  7. Click Test again:

    Lsd install 09b.png

    You may need to check authentication settings on the SQL Server. If you continue to have trouble, ask your SQL admin to debug the authentication issue.

    The recommended database name LaytonServiceDesk is suggested. If you are creating an additional database and a database called LaytonServiceDesk already exists, enter a different name.

    Click the Install Database button. Once complete, a dialog will confirm it:

    Lsd install 10.png

    Click the OK button to dismiss the dialog and return to the installer.
  8. Click the Close button to exit.

    Lsd install 11.png

Btn back up.png Back to Contents

Personal tools

Main Page
Online User Guides
General Support
Release Notes