Layton ServiceDesk - Settings - System Settings - Database Connection

From Layton Support
(Difference between revisions)
Jump to: navigation, search
m (Added Previous/Next links)
(Updated for 6.6.5)
 
(2 intermediate revisions by one user not shown)
Line 1: Line 1:
 
<p align="right">[[File:btn_back_up.png|link=User Guide for Layton ServiceDesk]] [[User Guide for Layton ServiceDesk|<u>Back to Contents</u>]]</p>
 
<p align="right">[[File:btn_back_up.png|link=User Guide for Layton ServiceDesk]] [[User Guide for Layton ServiceDesk|<u>Back to Contents</u>]]</p>
 
<p align="right">[[File:btn_back_up.png|link=Layton ServiceDesk - Settings - System Settings - Application Settings]] [[Layton ServiceDesk - Settings - System Settings - Application Settings |<u>Previous article in this series: ''Application Settings''</u>]]</p>
 
<p align="right">[[File:btn_back_up.png|link=Layton ServiceDesk - Settings - System Settings - Application Settings]] [[Layton ServiceDesk - Settings - System Settings - Application Settings |<u>Previous article in this series: ''Application Settings''</u>]]</p>
This page contains the database connection information. Layton ServiceDesk has the Connection (database server), Database, User ID and Password Fields.  
+
__FORCETOC__
 +
=Overview=
 +
This page contains the database connection information.
  
There is also an option to manually backup the database.  Specify the desired location in the backup path and then click on the Backup Database icon.
+
[[File:Lsd admin sys app db conn.png|center|link=]]
<p align="right">[[Layton ServiceDesk - Settings - System Settings - Application Terms |<u>Next article in this series: ''Application Terms''</u>]] [[File:Btn forward.png|link=Layton ServiceDesk - Settings - System Settings - Application Terms]]</p>
+
  
 +
=Settings=
 +
==Server==
 +
The name of the SQL Server. Note that if the SQL Server has an instance, the connection will be in the format ''SERVER\INSTANCE''.
 +
 +
==Database==
 +
The name of the Layton ServiceDesk database. by default, this is ''LaytonServiceDesk''.
 +
 +
==User ID (Blank = NT Trusted)==
 +
If the field is empty, NT authentication is used to connect to the SQL Server. If a user ID is specified, this will be a SQL user.
 +
 +
=Modifying Database Connection Settings=
 +
The '''[[Layton ServiceDesk - Installation - Connect to Existing Database|DBTool]]''' application is used to change connection settings.
 +
 +
=Backing Up Your Database=
 +
Use Microsoft SQL Server Management Studio to back up your database.
 +
<p align="right">[[Layton ServiceDesk - Settings - System Settings - Application Terms |<u>Next article in this series: ''Application Terms''</u>]] [[File:Btn forward.png|link=Layton ServiceDesk - Settings - System Settings - Application Terms]]</p>
 
<p align="right">[[File:btn_back_up.png|link=User Guide for Layton ServiceDesk]] [[User Guide for Layton ServiceDesk|<u>Back to Contents</u>]]</p>
 
<p align="right">[[File:btn_back_up.png|link=User Guide for Layton ServiceDesk]] [[User Guide for Layton ServiceDesk|<u>Back to Contents</u>]]</p>

Latest revision as of 02:19, 10 October 2016

Btn back up.png Back to Contents

Btn back up.png Previous article in this series: Application Settings

Contents

[edit] Overview

This page contains the database connection information.

Lsd admin sys app db conn.png

[edit] Settings

[edit] Server

The name of the SQL Server. Note that if the SQL Server has an instance, the connection will be in the format SERVER\INSTANCE.

[edit] Database

The name of the Layton ServiceDesk database. by default, this is LaytonServiceDesk.

[edit] User ID (Blank = NT Trusted)

If the field is empty, NT authentication is used to connect to the SQL Server. If a user ID is specified, this will be a SQL user.

[edit] Modifying Database Connection Settings

The DBTool application is used to change connection settings.

[edit] Backing Up Your Database

Use Microsoft SQL Server Management Studio to back up your database.

Next article in this series: Application Terms Btn forward.png

Btn back up.png Back to Contents

Personal tools
Namespaces

Variants
Actions
Main Page
Online User Guides
General Support
Release Notes
Toolbox